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.
In response to
pgsql-admin by date
|Next:||From: Guillaume Lelarge||Date: 2011-03-24 10:47:43|
|Subject: Re: Why pg_dump 'trust' authentication fails under root and
works under another user?|
|Previous:||From: Fujii Masao||Date: 2011-03-24 10:05:54|
|Subject: Re: Restarting recovery mode with pg_standby after failure|