problem with the postgres db user

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: problem with the postgres db user
Date: 2011-09-26 23:52:48
Message-ID: 232B5217AD58584C87019E8933556D1102F4C61692@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Everybody,
Am running into a problem with the following scenario:
I am not able to login as the db postgres user, on

Ubuntu 10.04 (Lucid Lynx)
Postgres 9.0.4

Postgres was installed with rpm for ubuntu
The password for the postgres user was set after installation
I am able to su to the postgres user with that password
I am able to start psql as the os postgres user

But
If I am logged in as anyone else and try: pgsql -U postgres and use the password - I get the following error:
Psql: FATAL: Ident authentication failed for user "postgers"

I tried altering the password for the postgres user, with:

ALTER USER postgres WITH ENCRYPTED PASSWORD 'password'

It tells me that it is successful. But I am still not able to use the new password.

pg_hba.conf, has no restriction on the postgres user, if fact it has no restriction on anyone:
host all all 0.0.0.0/0 md5

What am I missing?
Thanks,
Kasia

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-09-27 00:54:49 Re: problem with the postgres db user
Previous Message John DeSoi 2011-09-26 20:06:34 Re: problems logging in through phpPgAdmin