Authenticating user `postgres' - Mailing list pgsql-general

From Arcady Genkin
Subject Authenticating user `postgres'
Date
Msg-id r1zn13hua6j.fsf@bashful.cdf.toronto.edu
Whole thread Raw
Responses Re: Authenticating user `postgres'
List pgsql-general
Hello:

I have a pg_hba.conf question.  Currently the authentication is setup
as thus:

local   db1       password        passwd.db1
local   db2       password        passwd.db2
local   all       password        passwd.su

So, I store passwords for users in separate files for each database.
The third line is for the internal postgres templates.

The problem I'm having is that I want local UNIX user `postgres', who
is the database superuser, to be able to connect to any database
without a password.  I want, for example, to be able to run a cronjob
like "pg_dumpall >backup", but I can't do that with my current setup.

Any ideas?

Many thanks,
--
Arcady Genkin
i=1; while 1, hilb(i); i=i+1; end

pgsql-general by date:

Previous
From: Vic Cekvneich
Date:
Subject: Re: JDBC update wont, plz help.
Next
From: Mike Mascari
Date:
Subject: Re: Double Quoting Table Names????