pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (4+ messages)  latest in thread

Message-ID: <4783B8B5.2030708@dalibo.com>
Permalink:  ../4783B8B5.2030708@dalibo.com/
Also on:    postgresql.org/message-id/4783B8B5.2030708@dalibo.com

 · 

reply

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