Peter Eisentraut wrote: > Bruce Momjian writes: > > > Peter Eisentraut wrote: > > > > The pg_dumpall script seems to ignore the file and format switches > > > > that are used with pg_dump. pg_dumpall always writes to stdout in > > > > text format. Also, the -b switch can not be used with pg_dumpall > > > > since text output is being forced. > > > > > > That's not a bug. > > > > Peter, can you explain why to the user; it is not clear to me why > > either, though I have my suspicions, and shouldn't we throw an error to > > the user when they try it? > > The pg_dumpall reference page explicitly cautions against this situation.
Also, Peter, CVS pg_dumpall is not working for me. It isn't dumping any database contents. This new DATABASES line doesn't work in pg_dumpall: DATABASES="$DATABASES $DATABASE" The problem is that this is done inside a 'while' loop, so the value doesn't get outside the loop. I tested with BSD/OS sh and bash 2.02.1(2). #$ X=1 #$ echo 1 2 3 | while read X > do > X=2 > done #$ echo $X 1 -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster