Thread: pg_db_role_setting info not dumped

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?
--
Adrian Klaver
adrian.klaver@gmail.com

Adrian Klaver <adrian.klaver@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

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