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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
