Jeff Frost <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
