[jira] [Created] (HAWQ-169) pg_dumpall has wrong filespace sql and ignored the tablespace configuration for database.

["Dong Li (JIRA)" <ji...@apache.org>]

Dong Li created HAWQ-169:
----------------------------

             Summary: pg_dumpall has wrong filespace sql and ignored the tablespace configuration for database.
                 Key: HAWQ-169
                 URL: https://issues.apache.org/jira/browse/HAWQ-169
             Project: Apache HAWQ
          Issue Type: Bug
          Components: Command Line Tools
            Reporter: Dong Li
            Assignee: Lei Chang



{code}
create filespace fsfordump on hdfs ('localhost:8020/fsfordump');
create TABLESPACE tsfordump FILESPACE fsfordump;
create database dbfordum TABLESPACE tsfordump;
\c dbfordum
create TABLE tablefordum (i int) tablespace tsfordump;
insert into tablefordum select generate_series(1,100000);
\q
{code}
mkdir bkup
pg_dumpall -F > ./bkup/datawithfs
{code}
drop DATABASE dbfordum ;
drop TABLESPACE tsfordump ;
DROP FILESPACE fsfordump;
{code}
psql -d postgres ./bkup/datawithfs

The filespace can't be created successfully.
when we vi ./bkup/datawithfs, the contents are as follows.
{code}
--
-- Filespaces
--

CREATE FILESPACE dfs_system OWNER intern ON hdfs (
  0: 'localhost:8020/hawq_default'
) WITH (NUMREPLICA = 0);
CREATE FILESPACE fsfordump OWNER intern ON hdfs (
  0: 'localhost:8020/fsfordump'
) WITH (NUMREPLICA = 0);


--
-- Tablespaces
--

CREATE TABLESPACE tsfordump OWNER intern FILESPACE fsfordump;


--
-- Database creation
--

CREATE DATABASE dbfordum WITH TEMPLATE = template1 OWNER = intern ENCODING = 'UTF8';
{code}
The filespace sql is not correct and the database sql does contain the tablespace information.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)