problems with permissions

Поиск
Список
Период
Сортировка
Искать
От
Eric Smith
Тема
problems with permissions
Дата
Msg-id
976D12ED-9DD5-4CAB-B67A-E25486B7D80E@me.com
Список
Дерево обсуждения
problems with permissions Eric Smith <eric_h_smith@me.com>
Re: problems with permissions John R Pierce <pierce@hogranch.com>
Re: problems with permissions Adrian Klaver <adrian.klaver@aklaver.com>
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.

Any help is much appreciated!!

Regards,
Eric


В списке pgsql-general по дате отправления
От: David Ekren
Дата:
Сообщение: xml question
От: John R Pierce
Дата:
Сообщение: Re: problems with permissions
FAQ