> I suggest allowing the 'postgres' user to connect with 'ident sameuser'
> in pg_hba.conf from the localhost only, then always just run pg_dump as
> 'postgres'.
That means
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
host <mydb> <myuser> localhost 255.255.255.255
ident sameuser
only <myuser> will NOT be asked for password when it does
pg_dump -U <myuser>
when logged in to its shell account with <myuser>
and If I run a crontab with user <myuser> the above lines again stands true.
What you say ?
--
With Best Regards,
Vishal Kashyap.
Lead Software Developer,
http://saihertz.com,
http://vishalkashyap.tk