Re: Bug #631: pg_dumpall does not accept -F or -f - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: Bug #631: pg_dumpall does not accept -F or -f
Date
Msg-id 200204102319.g3ANJUa03686@candle.pha.pa.us
Whole thread Raw
In response to Re: Bug #631: pg_dumpall does not accept -F or -f  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #631: pg_dumpall does not accept -F or -f
Next
From: Bruce Momjian
Date:
Subject: Re: Bug #631: pg_dumpall does not accept -F or -f