On 04/25/2014 07:11 PM, Eric Smith wrote:
All,
Having a problem dumping a database using pg_dump. This is Mac OS 10.9.2 and
postgres 8.3. I'm using md5 for authentication, and have the appropriate
.pgpass file with u=rw permissions in the user's home directory. I can access
my database, called radiovision, using psql -U radiovision. I think that means
the authentication is working properly (i.e. postgres does not ask for a
password for radiovision or give me any authentication errors). However, when
I try to create a backup using pg_dump -C radiovision, I am prompted for a
password to which I respond with radiovision's password. I then get the error:
connection to database "radiovision" failed: FATAL: password authentication failed for
user "DrRudner".
Why is postgres asking for a password for DrRudner? This is the mac username
of the user currently logged in, and also the user that installed postgres
initially.
Because in the absence of the -U argument Postgres will use the default
user, which is the logged in user. Per Johns post use -U to eliminate
the guesswork:)
Any help is much appreciated!!
Regards,
Eric
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
