user login: problems in linux

From: dr_pompeii <dr_pompeii(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: user login: problems in linux
Date: 2008-01-08 04:26:08
Message-ID: 14682233.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Dear members

i work in linux fedora core 5
and i am rookie with postgresql 8.2.4

i cant understand this behaviour

i only can loggin in postgres with superuser and not like a simple user

see that "root" is a user for postgresql

usename | usesysid | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
postgres | 10 | t | t | t | ******** |
|
root | 16395 | t | t | t | ******** |
|
(2 filas)

[SomeUser(at)localhost ~]$ su
Contraseña:
[root(at)localhost SomeUser]# psql -d somedb -U root
Bienvenido a psql 8.2.4, la terminal interactiva de PostgreSQL.

Digite: \copyright para ver los términos de distribución
\h para ayuda de comandos SQL
\? para ayuda de comandos psql
\g o or termine con punto y coma para ejecutar una consulta
\q para salir

somedb=#

see that i need logged like root in linux (#)
to enter

but
it fall if i am not root in linux, thats mean $

[SomeUser(at)localhost ~]$ psql -d somedb -U root
Contraseña para usuario root:
psql: FATAL: la autentificación Ident falló para el usuario «root»
[SomeUser(at)localhost ~]$ psql -d somedb -U root
psql: FATAL: la autentificación Ident falló para el usuario «root»
[SomeUser(at)localhost ~]$

how i can resolver this??
i cant get a successful connection with my java application and i cant
use my aqua data studio to make the connection and test some queries

and worst

according with the manual

-W preguntar contraseña (debería suceder automáticamente)

ask the password automatically

but this never happens, what is wrong?

here my pg_hba.conf
located in
[root(at)localhost pgsql]# pwd
/usr/share/pgsql

host panamotor root 127.0.0.1/32 255.255.255.255 trust

thanks in advanced
--
View this message in context: http://www.nabble.com/user-login%3A-problems-in-linux-tp14682233p14682233.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Suresh Gupta VG 2008-01-08 07:39:36 Re: Need some info on Postgresql
Previous Message Geoffrey 2008-01-07 17:43:33 Re: When does VACUUM FULL not clean out all deleted data?