Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 51D082E38E9 for ; Tue, 8 Jan 2008 13:54:39 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36517-02-4 for ; Tue, 8 Jan 2008 13:54:34 -0400 (AST) Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id DBEB72E4197 for ; Tue, 8 Jan 2008 13:54:33 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id 5B4E457806D; Tue, 8 Jan 2008 18:54:32 +0100 (CET) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zBjLhdShlQQl; Tue, 8 Jan 2008 18:54:32 +0100 (CET) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id 3EDAE578072; Tue, 8 Jan 2008 18:54:32 +0100 (CET) Received: from [192.168.0.11] (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by pyrrha.dalibo.net (Postfix) with ESMTP id C840557806D; Tue, 8 Jan 2008 18:54:29 +0100 (CET) Message-ID: <4783B8B5.2030708@dalibo.com> Date: Tue, 08 Jan 2008 18:53:57 +0100 From: =?ISO-8859-1?Q?C=E9dric_Villemain?= Organization: Dalibo User-Agent: Mozilla-Thunderbird 2.0.0.9 (X11/20080103) MIME-Version: 1.0 To: Andrew Sullivan , pgsql-admin@postgresql.org, dr_pompeii@yahoo.com Subject: Re: user login: problems in linux References: <14682233.post@talk.nabble.com> <20080108172549.GE23841@crankycanuck.ca> In-Reply-To: <20080108172549.GE23841@crankycanuck.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/86 X-Sequence-Number: 27860 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