« Return to Thread: user login: problems in linux

Re: user login: problems in linux

by Cédric Villemain :: Rate this Message:

Reply to Author | View in Thread

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


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

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

 « Return to Thread: user login: problems in linux