On Friday 14 January 2011 2:52:18 pm Tom Lane wrote: > Adrian Klaver <adrian.klaver@xxxxxxxxx> writes: > > Postgres 9.0.2 > > I used the ALTER DATABASE command to create a database specific SET > > configuration. The problem is that information does not seem to be > > dumped. I have tried pg_dumpall -g, pg_dumpall as well as a pg_dump for > > the individual database. Am I missing something? > > Should be dumped by pg_dumpall (without the -g option). > > There has been debate about whether plain pg_dump should deal with such > things, but nothing's been changed yet. > > regards, tom lane pg_dumpall worked. I missed it on my previous look. I vote for having it included in the plain pg_dump output. -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
