BUG #14315: pg_dump --no-tablespaces doesn't do it's job when --create specified

From: abcz2(dot)uprola(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14315: pg_dump --no-tablespaces doesn't do it's job when --create specified
Date: 2016-09-08 08:19:53
Message-ID: 20160908081953.1402.75347@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14315
Logged by: Danylo Hlynskyi
Email address: abcz2(dot)uprola(at)gmail(dot)com
PostgreSQL version: 9.5.4
Operating system: Amazon Linux
Description:

I have a database in custom tablespace and I want to pg_dump/pg_restore it
in another place without tablespace.

But I noticed that --no-tablespaces doesn't change --create option to not
include tablespaces:

$ pg_dump -C --schema-only -U postgres -h test --no-tablespaces -d
wp_analytics | grep "CREATE DATABASE"
CREATE DATABASE wp_analytics WITH TEMPLATE = template0 ENCODING = 'UTF8'
LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8' TABLESPACE =
wp_tblspc;

I think that it is a bug. If I specify --create and --no-tablespaces
together than "TABLESPACE = wp_tblspc" should be absent in resulting
command.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ozzi_99 2016-09-08 09:45:56 BUG #14316: union all with order by "missing from-clause"
Previous Message Richa Rathore 2016-09-08 07:35:09 Want a routine vacuum for postgres