[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    [BUGS] BUG #12269: small incosistency in pg_dump and pg_dumpall dumps
From:       not-available () somewhere ! com
Date:       2014-12-18 8:52:26
Message-ID: 20141218085226.1237.59424 () wrigleys ! postgresql ! org
[Download RAW message or body]

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.



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
[prev in list] [next in list] [prev in thread] [next in thread]