Re: Permissions

On Tue, 27 Feb 2001, Heath Johns wrote:

> 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?

You need something like this in your $PGDATA/pg_hba.conf file:

local        postgres                                      trust
local        template1                                     trust
host         all         127.0.0.1     255.255.255.255     password

-- Brett
                                     http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
Carmel, New York, has an ordinance forbidding men to wear coats and
trousers that don't match.