Bypassing authentication - Mailing list pgsql-novice

From Andre Majorel
Subject Bypassing authentication
Date
Msg-id 20100708201926.GB2132@aym.net2.nerim.net
Whole thread Raw
Responses Re: Bypassing authentication
Re: Bypassing authentication
List pgsql-novice
Is there a way to have psql bypass authentication as joe if the
system user running psql is postgres, the way su doesn't ask for
password if you are root ?

sudo -u postgres psql -l         # psql doesn't ask for a password
sudo -u postgres psql -u joe -l  # psql asks for joe's password

joe is just a PostgreSQL role with no system counterpart so the
"local all all ident sameuser" catch-all in pg_hba.conf is of no
help here.

Thanks in advance.

--
André Majorel http://www.teaser.fr/~amajorel/

pgsql-novice by date:

Previous
From: Arvind Sharma
Date:
Subject: Re: Triggers, Stored Procedures to Aggregate table ?
Next
From: "John T. Dow"
Date:
Subject: Re: Dropped table, no backup, restore from file system backup or WAL files?