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

• Re: Full backup - pg_dumpall sufficient? at 2009-01-30 02:34:04 from Jeff Frost

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?