Re: Problems with authentication - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problems with authentication
Date
Msg-id 24536.1043272553@sss.pgh.pa.us
Whole thread Raw
In response to Problems with authentication  (Frans Haarman <frans@haarman.com>)
List pgsql-admin
Frans Haarman <frans@haarman.com> writes:
> I tried:
> local all password
> but then it asks for a password when booting the server, and I would
> like to have this done automaticly.

You could tell the pg_ctl script not to try to check whether the
postmaster started; then it won't need to connect and so won't need
a password.  I forget the switch for this, but it's in the docs.

But in general, password auth is a pain in the neck for all admin
duties.  I agree with Bruno Wolff's suggestion to look at alternative
auth methods.  "ident" on local connections is secure, if your operating
system supports it.

            regards, tom lane

pgsql-admin by date:

Previous
From: Matt Mello
Date:
Subject: Re: Failed to compile 7.3.1 under Sol7 - can't find libz.so
Next
From: Tom Lane
Date:
Subject: Re: Access PGDATA from different servers