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.