Re: problems with permissions

On 4/25/2014 7:11 PM, Eric Smith wrote:
> 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".

try pg_dump -U radiovision -C radiovision ...

--
john r pierce 37N 122W
somewhere on the middle of the left coast