On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y <mary.y.wang@xxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
