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

["Lei Chang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HAWQ-169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lei Chang closed HAWQ-169.
--------------------------

> 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: Ming LI
>             Fix For: 2.0.0
>
>
> {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)