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.
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 |