Bypassing authentication

From: Andre Majorel <aym-2lqsgp(at)teaser(dot)fr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Bypassing authentication
Date: 2010-07-08 20:19:26
Message-ID: 20100708201926.GB2132@aym.net2.nerim.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message John T. Dow 2010-07-08 20:28:59 Re: Dropped table, no backup, restore from file system backup or WAL files?
Previous Message Arvind Sharma 2010-07-08 19:49:52 Re: Triggers, Stored Procedures to Aggregate table ?