Re: pg_db_role_setting info not dumped - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_db_role_setting info not dumped
Date
Msg-id 13331.1295045538@sss.pgh.pa.us
Whole thread Raw
In response to pg_db_role_setting info not dumped  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: pg_db_role_setting info not dumped  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: array_agg-like thing over arrays
Next
From: Andrew Sullivan
Date:
Subject: Re: array_agg-like thing over arrays