Re: Why pg_dump 'trust' authentication fails under root and works under another user? - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Date
Msg-id 4D8B1C09.4050609@lelarge.info
Whole thread Raw
In response to Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Jaroslav Záruba <jaroslav.zaruba@gmail.com>)
List pgsql-admin
Le 24/03/2011 10:39, Jaroslav Záruba a écrit :
> The command line is still the same, when executed under one user it does not
> ask for password, when executed under another (root that is) it does:
> pg_dump --ignore-version --host=localhost --port=5432 --username=postgres
> --file="$BACKUP_FILE" --format=p --column-inserts --encoding=UTF-8 db123
>

The "--host=localhost" option says you're using TCP/IP connection (so
the "host lines" of pg_hba.conf), so it's asking for md5 authentication.
Hence the password.

If one user is not asked for a password, it could be that this user has
a .pgpass file telling pg_dump which password to use.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com

pgsql-admin by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Restarting recovery mode with pg_standby after failure
Next
From: Brett Parker
Date:
Subject: Re: Why pg_dump 'trust' authentication fails under root and works under another user?