From: Cédric Villemain <cedric.villemain@dalibo.com>
To: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
To: dr_pompeii@yahoo.com
Subject: Re: user login: problems in linux
Date: Tue, 08 Jan 2008 18:53:57 +0100
Message-ID: <4783B8B5.2030708@dalibo.com> (raw)
In-Reply-To: <20080108172549.GE23841@crankycanuck.ca>
References: <14682233.post@talk.nabble.com>
<20080108172549.GE23841@crankycanuck.ca>
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
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: cedric.villemain@dalibo.com, ajs@crankycanuck.ca, dr_pompeii@yahoo.com
Subject: Re: user login: problems in linux
In-Reply-To: <4783B8B5.2030708@dalibo.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