Re: dump vs dumpall

On Mon, 16 Oct 2000, Peter Eisentraut wrote:

> Darrin Ladd writes:
>
> > I am in the process of moving my postgres dbs from an Alpha to a Pentium box
> > and I can't seem to get pg_dumpall to work.  I have password authentication
> > enabled and am using the -u option on pg_dumpall, but it never actually asks
> > me for a userid or password, it just writes out that the password
> > authentication on postgres failed.
>
> pg_dumpall doesn't work very well at all with password authentication.
> You might be better off temporarily using some other mechanism.  (E.g.,
> use the Unix socket with "trust", but change the permissions on the socket
> itself.)

Try to do it this way:
$ export PGUSER=username
$ export PGPASSWORD=password
$ pg_dumpall > filename

Regards
Robert "BoBsoN" Partyka

BTW... Hello to all on the list ;)