Le 24/03/2011 08:34, Jaroslav ZÃruba a Ãcrit : > Hello > > I have pg_dump command in cron that accesses PostgreSQL under user postgres > and does not provide a password. > > pg_dump --username=postgres ... > > I have set in pg_hba.conf that user postgres should be trusted for all > databases from localhost. > > local all postgres trust > > When I run the command under regular user it works. > When I run it under root (sudo -i) it requires password, and therefore the > crontab task fails to authenticate. > Are you sure the password is not asked by the sudo command, rather than by the pg_dump one? -- 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
