pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeduser login: problems in linux
4+ messages / 3 participants
[nested] [flat]
* user login: problems in linux
@ 2008-01-08 04:26 dr_pompeii <dr_pompeii@yahoo.com>
2008-01-08 17:25 ` Re: user login: problems in linux Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 4+ messages in thread
From: dr_pompeii @ 2008-01-08 04:26 UTC (permalink / raw)
To: 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@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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user login: problems in linux
2008-01-08 04:26 user login: problems in linux dr_pompeii <dr_pompeii@yahoo.com>
@ 2008-01-08 17:25 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-01-08 17:53 ` Re: user login: problems in linux Cédric Villemain <cedric.villemain@dalibo.com>
0 siblings, 1 reply; 4+ messages in thread
From: Andrew Sullivan @ 2008-01-08 17:25 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user login: problems in linux
2008-01-08 04:26 user login: problems in linux dr_pompeii <dr_pompeii@yahoo.com>
2008-01-08 17:25 ` Re: user login: problems in linux Andrew Sullivan <ajs@crankycanuck.ca>
@ 2008-01-08 17:53 ` Cédric Villemain <cedric.villemain@dalibo.com>
2008-01-08 18:13 ` Re: user login: problems in linux Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Cédric Villemain @ 2008-01-08 17:53 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin; dr_pompeii@yahoo.com
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: user login: problems in linux
2008-01-08 04:26 user login: problems in linux dr_pompeii <dr_pompeii@yahoo.com>
2008-01-08 17:25 ` Re: user login: problems in linux Andrew Sullivan <ajs@crankycanuck.ca>
2008-01-08 17:53 ` Re: user login: problems in linux Cédric Villemain <cedric.villemain@dalibo.com>
@ 2008-01-08 18:13 ` Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 4+ messages in thread
From: Andrew Sullivan @ 2008-01-08 18:13 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-01-08 18:13 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-08 04:26 user login: problems in linux dr_pompeii <dr_pompeii@yahoo.com>
2008-01-08 17:25 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-01-08 17:53 ` Cédric Villemain <cedric.villemain@dalibo.com>
2008-01-08 18:13 ` Andrew Sullivan <ajs@crankycanuck.ca>
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