On Thu, May 13, 2010 at 11:50 AM, Wang, Mary Y <mary(dot)y(dot)wang(at)boeing(dot)com> 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.