Re: dump vs dumpall

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.)

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/