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
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 Ringer||Date: 2009-01-30 03:37:11|
|Subject: Re: Pet Peeves?|
|Previous:||From: Jeff Frost||Date: 2009-01-30 02:34:04|
|Subject: Re: Full backup - pg_dumpall sufficient?|