Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id A67F42E2F1E for ; Tue, 8 Jan 2008 00:26:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 76935-09 for ; Tue, 8 Jan 2008 00:26:10 -0400 (AST) Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 714AE2E34B0 for ; Tue, 8 Jan 2008 00:26:10 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1JC62S-0002mk-Cw for pgsql-admin@postgresql.org; Mon, 07 Jan 2008 20:26:08 -0800 Message-ID: <14682233.post@talk.nabble.com> Date: Mon, 7 Jan 2008 20:26:08 -0800 (PST) From: dr_pompeii To: pgsql-admin@postgresql.org Subject: user login: problems in linux MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Nabble-From: dr_pompeii@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/80 X-Sequence-Number: 27854 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 | ******** | = =20 | root | 16395 | t | t | t | ******** | = =20 | (2 filas) [SomeUser@localhost ~]$ su Contrase=C3=B1a: [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=C3=A9rminos de distribuci=C3=B3n \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=3D# 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=C3=B1a para usuario root: psql: FATAL: la autentificaci=C3=B3n Ident fall=C3=B3 para el usuario =C2= =ABroot=C2=BB [SomeUser@localhost ~]$ psql -d somedb -U root psql: FATAL: la autentificaci=C3=B3n Ident fall=C3=B3 para el usuario =C2= =ABroot=C2=BB [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=C3=B1a (deber=C3=ADa suceder autom=C3= =A1ticamente) 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 =09panamotor root=09127.0.0.1/32 =09 255.255.255.255 trust thanks in advanced --=20 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.