Обсуждение: user login: problems in linux
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.
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
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: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org
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