pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: dr_pompeii <dr_pompeii@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: user login: problems in linux
Date: Mon, 7 Jan 2008 20:26:08 -0800 (PST)
Message-ID: <14682233.post@talk.nabble.com> (raw)


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 	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.




view thread (4+ messages)  latest in thread

Message-ID: <14682233.post@talk.nabble.com>
Permalink:  ../14682233.post@talk.nabble.com/
Also on:    postgresql.org/message-id/14682233.post@talk.nabble.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: dr_pompeii@yahoo.com
  Subject: Re: user login: problems in linux
  In-Reply-To: <14682233.post@talk.nabble.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox