Cannot connect using psql

From: "Nick Black" <nickblack1(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Cannot connect using psql
Date: 2006-10-31 18:09:16
Message-ID: 223020e60610311009x5fab442cg8c3284e98e1733e4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello,

I am having difficuilties connected to the postgres server. I asked
on IRC, but everyone was stumped, so here we go.

My pg_hba.conf file:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all trust

# IPv4 local connections:
host all all 127.0.0.1/32 trust

# IPv6 local connections:
host all all ::1/128 trust
host all all 10.0.0.0/16 trust

I have postgres users called postgres, nick and osm and unix users
called nick and postgres. I created users nick and osm using the
createuser script.

I can connect to postgres and nick without any problems, but if I try
to connect to osm, the following happens:

nick(at)pmdev $ psql -U osm -W -d template1
Password for user osm:
psql: FATAL: Ident authentication failed for user "osm"

But ident is not included in the config file, which made me think that
the file wasnt being read. So ammended the entry for local to

local all all password

restarted, and was prompted for a password.

I am really confused as to the issue. I thought that postgres treated
unix users and postgres users seperately. It seems strange that I can
connect using user nick (the name of a unix user and a postgres user).

Thanks in advance,

Nick

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nick Black 2006-10-31 18:52:37 Re: Cannot connect using psql
Previous Message Stan Horwitz 2006-10-31 16:51:06 Uninstalling on Mac OS X 10.4