Re: Why pg_dump 'trust' authentication fails under root and works under another user?

[Simon <simon@xxxxxxxxxxxxxxxxxxxxxxx>]

I don't know why postgres is prompting for a password. But you could try putting the following in your crontab:

su postgres -c 'pg_dump ...' 

Simon

2011/3/24 Jaroslav ZÃruba <jaroslav.zaruba@xxxxxxxxx>

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.

(I'm looking at both users' 'export' command output, and there seems to be nothing related to PostgreSQL.)

Could someone explain to me what is happening here?

Regards
ÂÂJ. ZÃruba