Re: user login: problems in linux

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-admin(at)postgresql(dot)org, dr_pompeii(at)yahoo(dot)com
Subject: Re: user login: problems in linux
Date: 2008-01-08 17:53:57
Message-ID: 4783B8B5.2030708@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2008-01-08 18:13:33 Re: user login: problems in linux
Previous Message Andrew Sullivan 2008-01-08 17:25:49 Re: user login: problems in linux