BUG #12269: small incosistency in pg_dump and pg_dumpall dumps - Mailing list pgsql-bugs

From not-available@somewhere.com
Subject BUG #12269: small incosistency in pg_dump and pg_dumpall dumps
Date
Msg-id 20141218085226.1237.59424@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12269
Logged by:          anonym
Email address:      not-available@somewhere.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.

pgsql-bugs by date:

Previous
From: Jan Hink
Date:
Subject: Create into temp table as select doesn set "found"
Next
From: jaksits.tibor@gmail.com
Date:
Subject: BUG #12273: CASE Expression BUG