BUG #12269: small incosistency in pg_dump and pg_dumpall dumps

From: not-available(at)somewhere(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12269: small incosistency in pg_dump and pg_dumpall dumps
Date: 2014-12-18 08:52:26
Message-ID: 20141218085226.1237.59424@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: 12269
Logged by: anonym
Email address: not-available(at)somewhere(dot)com
PostgreSQL version: 9.3.5
Operating system: Fedora
Description:

when dumping database with "pg_dump -Cs" and "pg_dumpall -s" I get

"CREATE DATABASE ... WITH TEMPLATE = ... ENCODING = ... LC_COLLATE = ...
LC_CTYPE = ...;"

and

"CREATE DATABASE ... WITH TEMPLATE = ... OWNER = ....;"

respectively. I would prefer to get ENCODING, LC_COLLATE... and other
attributes both times as it can be important on systems with different
database and system encoding settings.

Also, I think permissions (and comments etc.) on database level should be
dumped with "pg_dump -C" or there should be an option allowing to dump this
information.

Browse pgsql-bugs by date

  From Date Subject
Next Message Jan Hink 2014-12-18 09:30:51 Create into temp table as select doesn set "found"
Previous Message Mark Kirkwood 2014-12-17 20:52:12 Re: BUG #12258: run php file