I need every postgres account to be authenticated by password. However
I would also like to have the local unix user 'postgres' to be able to
bypass that password authentication. The reason is that I have a cron
job that calls pg_dump under that account and I would rather not have to
put the master password for my rdbms in a script.
I imagine this is a common scenario. Any thoughts?
Thanks,
Heath Johns