From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pg_db_role_setting info not dumped |
Date: | 2011-01-15 00:01:27 |
Message-ID: | 201101141601.28037.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gunnar Wolf | 2011-01-15 00:07:36 | Re: Oferta de un nuevo Entrenamiento en el marco del Tercer PGDay Latinoamericano. |
Previous Message | Jasen Betts | 2011-01-14 23:36:28 | Re: migrate hashname function from 8.1.x to 8.4 |