On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y <[email protected]> wrote: > it looks like pg_dumpall > outfile is the best choice. I'd like to ask the > community to reconfirm.
We do an individual pg_dump on each DB separately, using the '-Fc' format. The only thing we miss from pg_dumpall we get via "pg_dumpall --globals-only > globals.sql". The "c" format is much more flexible to restore bits of the database with judicious use of pg_restore and awk or grep. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
