user login: problems in linux

[dr_pompeii]

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@localhost ~]$ su
Contraseña:
[root@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@localhost ~]$ psql -d somedb -U root
Contraseña para usuario root:
psql: FATAL:  la autentificación Ident falló para el usuario «root»
[SomeUser@localhost ~]$ psql -d somedb -U root
psql: FATAL:  la autentificación Ident falló para el usuario «root»
[SomeUser@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@localhost pgsql]# pwd
/usr/share/pgsql


host somedb   root 127.0.0.1/32      255.255.255.255 trust

thanks in advanced

[Andrew Sullivan-8]

On Mon, Jan 07, 2008 at 08:26:08PM -0800, dr_pompeii wrote:
> i only can loggin in postgres with superuser and not like a simple user
>
> see that "root" is a user for postgresql

You're not allowed to log in as root.  Period.  Use a different user.  There
is no possible way you should be doing this as root anyway.

A


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Cédric Villemain]

Andrew Sullivan a écrit :

> On Mon, Jan 07, 2008 at 08:26:08PM -0800, dr_pompeii wrote:
>  
>> i only can loggin in postgres with superuser and not like a simple user
>>
>> see that "root" is a user for postgresql
>>    
>
> You're not allowed to log in as root.  Period.  Use a different user.  There
> is no possible way you should be doing this as root anyway.
>
> A
>
>  

I like to suggest you (dr_pompei) to have a look at the docs about
pg_hba.conf.

Andrew, it seems "root" is here a postgresql user (which have rights to
connect to "somedb")

--
Cédric Villemain
Administrateur de Base de Données
Cel: [phone]
http://dalibo.com - http://dalibo.org


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

                http://www.postgresql.org/about/donate

[Andrew Sullivan-8]

On Tue, Jan 08, 2008 at 06:53:57PM +0100, Cédric Villemain wrote:
> Andrew, it seems "root" is here a postgresql user (which have rights to
> connect to "somedb")

Yeah, I see that now.  It's still a foolish idea.

A

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq