Re: [ADMIN] problem with the postgres db user

2011-09-26 Thread Tom Lane
Kasia Tuszynska writes: > 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" That's what's supposed to happen, if you're using ident authentication. If you want to be abl

[ADMIN] problem with the postgres db user

2011-09-26 Thread Kasia Tuszynska
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