Re: dump vs dumpall

Thanks! That worked perfectly!!

-----Original Message-----
From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Darrin Ladd <dladd(at)newfoundcomm(dot)net>
Cc: pgsql-general(at)postgresql(dot)org <pgsql-general(at)postgresql(dot)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(at)gmx(dot)net http://yi.org/peter-e/
>