Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id DC4EA2E008D for ; Tue, 8 Jan 2008 13:26:17 -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 25678-09 for ; Tue, 8 Jan 2008 13:26:14 -0400 (AST) Received: from main1.mycybernet.net (main1.mycybernet.net [209.222.63.135]) by postgresql.org (Postfix) with ESMTP id CE9032E3231 for ; Tue, 8 Jan 2008 13:26:14 -0400 (AST) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main1.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JCID3-0005l5-SK for pgsql-admin@postgresql.org; Tue, 08 Jan 2008 12:25:53 -0500 Received: by crankycanuck.ca (Postfix, from userid 1000) id 40AE44FFE1; Tue, 8 Jan 2008 12:25:49 -0500 (EST) Date: Tue, 8 Jan 2008 12:25:49 -0500 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: user login: problems in linux Message-ID: <20080108172549.GE23841@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <14682233.post@talk.nabble.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <14682233.post@talk.nabble.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/85 X-Sequence-Number: 27859 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