Re: regular backups - super user - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: regular backups - super user
Date
Msg-id 20031101172704.GB20268@wolff.to
Whole thread Raw
In response to Re: regular backups - super user  (Stuart Johnston <sjohnston@haisolutions.com>)
List pgsql-general
On Fri, Oct 31, 2003 at 15:48:31 -0600,
  Stuart Johnston <sjohnston@haisolutions.com> wrote:
>
> If your users always connect through TCP/IP then you can set local
> connections to not use passwords but I'm pretty sure there is no way to
> configure this just for the postgres user (I wish you could).

In recent versions you can specify user, database pairs in authentication
rules so that you can restrict an authentication rule to just apply
to use "postgres".

Ident authentication on OS's that support the equivalent of getpeerid will
also allow you to do this kind of thing.

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: grant all to database inheritence
Next
From: George Essig
Date:
Subject: Re: [SQL] connectby