Re: dump vs dumpall

Thanks!  That worked perfectly!!


-----Original Message-----
From: Peter Eisentraut <peter_e@gmx.net>
To: Darrin Ladd <dladd@newfoundcomm.net>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Date: Monday, October 16, 2000 1:41 PM
Subject: Re: [GENERAL] 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/
>