[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: sql-postgresql authentication failure

From: Sebastian P. Luque
Subject: Re: sql-postgresql authentication failure
Date: Fri, 25 May 2007 08:07:25 -0500
User-agent: Gnus/5.110006 (No Gnus v0.6) Emacs/22.0.990 (gnu/linux)

On Fri, 25 May 2007 15:28:56 +1000,
Tim X <address@hidden> 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


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

Thanks again,


reply via email to

[Prev in Thread] Current Thread [Next in Thread]