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.
Could someone explain to me what is happening here?
Disclaimer: I am Linux n00b.