[
https://issues.apache.org/jira/browse/HAWQ-169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ming LI resolved HAWQ-169.
--------------------------
Resolution: Fixed
> 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
>
> {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)
