Re: sql-postgresql authentication failure

[Sebastian P. Luque]

On Fri, 25 May 2007 15:28:56 +1000,
Tim X <timx@nospam.dev.null> wrote:

[...]

> the second method may work and is easier, but no guarantee. It is
> possible that if you set specific switches, the psql client that sql
> mode uses will use local non-password based authentication. While
> sql-mode will still prompt you for the username/password, this
> information will be ignored by the psql client and you will get
> authenticated.based on the user that is running the psql client (i.e.
> you).

Thanks for your comments Tim.  This is very much what I'd like to do,
i.e. I don't want to modify the way I access the server.  I presume you
mean one can put these switches in sql-postgres-options, but I don't see
any options in 'man psql' that would allow for this scenario.  What
particular options would you use?  Below is my
/etc/postgresql/8.2/main/pg_hba.conf file:

---<---------------cut here---------------start-------------->---
# Database administrative login by UNIX sockets
local   all         postgres                          ident sameuser

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident sameuser
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5
---<---------------cut here---------------end---------------->---


Thanks again,

-- 
Seb