Skip site navigation (1) Skip section navigation (2)

Re: Full backup - pg_dumpall sufficient?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Gerhard Wiesinger <lists(at)wiesinger(dot)com>, "Raymond O'Donnell" <rod(at)iol(dot)ie>, pgsql-general(at)postgresql(dot)org
Subject: Re: Full backup - pg_dumpall sufficient?
Date: 2009-01-30 02:39:37
Message-ID: 22796.1233283177@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
>> I guess I could pg_dumpall -s | grep "ALTER DATABASE" to grab that stuff.

> That seems silly.  Is this the best way to find this data:

> SELECT name, setting FROM pg_settings where source = 'database' ORDER BY
> name;               

No, you'd miss anything overridden locally in your session.

I'd think about getting it out of pg_database.datconfig, instead.
Or really the easiest way is to tweak the logic in pg_dumpall about
what to dump when ...

			regards, tom lane

In response to

pgsql-general by date

Next:From: Craig RingerDate: 2009-01-30 03:37:11
Subject: Re: Pet Peeves?
Previous:From: Jeff FrostDate: 2009-01-30 02:34:04
Subject: Re: Full backup - pg_dumpall sufficient?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group