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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
