Le 24/03/2011 08:34, Jaroslav Záruba a écrit :
> 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?
In response to
pgsql-admin by date
|Next:||From: lst_hoe02||Date: 2011-03-24 08:32:45|
|Subject: Re: About migration to Postgre|
|Previous:||From: Simon||Date: 2011-03-24 07:49:51|
|Subject: Re: Why pg_dump 'trust' authentication fails under root and
works under another user?|