Re: pg_db_role_setting info not dumped

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