On Friday 14 January 2011 2:52:18 pm Tom Lane wrote:
> Adrian Klaver <adrian.kla...@gmail.com> 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.kla...@gmail.com

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to