Re: pg_db_role_setting info not dumped

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: adrian(dot)klaver(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_db_role_setting info not dumped
Date: 2011-01-14 22:52:18
Message-ID: 13331.1295045538@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2011-01-14 23:21:32 Re: array_agg-like thing over arrays
Previous Message Dmitriy Igrishin 2011-01-14 22:35:20 Re: array_agg-like thing over arrays