Re: Bug #631: pg_dumpall does not accept -F or -f

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: donald(dot)a(dot)pellegrino(at)usa(dot)dupont(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #631: pg_dumpall does not accept -F or -f
Date: 2002-04-10 23:19:30
Message-ID: 200204102319.g3ANJUa03686@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2002-04-11 04:55:12 Re: Bug #631: pg_dumpall does not accept -F or -f
Previous Message Tom Lane 2002-04-10 22:59:35 Re: Bug #631: pg_dumpall does not accept -F or -f