Search Postgresql Archives

Re: problems with permissions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux