Thread

Re: Authenticating user `postgres'

Arcady Genkin <a.genkin@utoronto.ca> — 2001-09-27T22:37:21Z

Alvaro Herrera <alvherre@atentus.com> writes:

> > 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.
> 
> You have at least two possible ways to solve this:
> 1. use the PGPASSWORD environment variable to hold the postgres
> password.

But what if user 'postgres' has different passwords in different
databases?  Or is it only template[12] that matter for pg_dumpall?

> 2. use a "ident" entry in pg_hba.conf to authorize only localhost.

But I only want UNIX user *postgres* to be able to connect without
password.

> I remember there being a "match" auth-type...

It isn't in the docs...
http://www.postgresql.org/idocs/index.php?client-authentication.html

Thank you for your reply,
-- 
Arcady Genkin
i=1; while 1, hilb(i); i=i+1; end