Jeff Frost wrote: > On Thu, 29 Jan 2009, Tom Lane wrote: > >> Jeff Frost <jeff@xxxxxxxxxxxxxxxxxxxxxx> writes: >>> Tom one thing I noticed recently is that pg_dumpall --globals doesn't >>> seem to pick up when you alter the GUCs at the database level and >>> neither does pg_dump. How should you dump to grab that per-database >>> stuff? >> >> Regular pg_dumpall will catch that. >> >> There's been some previous discussion about redrawing the dividing lines >> so that this doesn't fall between the cracks when you try to use >> --globals plus per-database pg_dump, but AFAIR nothing's been done about >> it yet. It's a bit tricky since it's not entirely clear who's >> responsible for creating the individual databases when you restore in >> that scenario. > > 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; ? -- Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 916-647-6411 FAX: 916-405-4032 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
