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/
>