Package: postgresql-common
Version: 94lenny1
Severity: normal

pg_upgradecluster doesn't preserve the contents of pg_database.datconfig
or pg_database.datacl.

(That is, it doesn't preserve the results of 'GRANT foo ON DATABASE bar
TO baz' or 'ALTER DATABASE name SET foo TO bar'.)

I think bug 539772 is a specific case of this issue.


This information isn't provided by either pg_dump or pg_dumpall -g. It
is included in the output of pg_dumpall -s, in the 'Database creation'
section.

Possible strategies for implementing this in pg_upgradecluster might be
to parse the information out of the 'pg_dumpall -s' output, or to
duplicate the dumpCreateDB logic from pg_dumpall.



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to