X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id ABF4D9DCAEF for ; Tue, 28 Mar 2006 14:21:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26201-01 for ; Tue, 28 Mar 2006 14:21:30 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31805.mail.mud.yahoo.com (web31805.mail.mud.yahoo.com [68.142.207.68]) by postgresql.org (Postfix) with SMTP id B8E579DCA2D for ; Tue, 28 Mar 2006 14:21:28 -0400 (AST) Received: (qmail 59191 invoked by uid 60001); 28 Mar 2006 18:21:28 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2laY8CRo9Ajxr7Z8r2SR/hpgkrElh8LOIppCDpB+FqeBEvz1PH6lhI4mLOIL6TCttqsrYcRSKndsUuGg+gv3T5hQ1IvEjmqZhD1d0cFXui4rMVKfi9P16YxVrv3IwHIzZiCIQ9TWA9JoJDRAYMvdn++wS/6oWugC71G6GpV925E= ; Message-ID: <20060328182128.59189.qmail@web31805.mail.mud.yahoo.com> Received: from [63.203.180.122] by web31805.mail.mud.yahoo.com via HTTP; Tue, 28 Mar 2006 10:21:28 PST Date: Tue, 28 Mar 2006 10:21:28 -0800 (PST) From: Richard Broersma Jr Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! To: lmyho , pgsql-admin@postgresql.org In-Reply-To: <20060328174105.88779.qmail@web30806.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/314 X-Sequence-Number: 21071 > How should I do this? The current auto-generated pg_hba.conf file read as: > "local all postgres ident sameuser" > on the first line, and the first line also after the # TYPE DATABASE....METHOD line. > > > Do you mean I should change the "ident sameuser" at the end to "trust"? Below is a snippet from: http://www.postgresql.org/docs/8.0/static/client-authentication.html#EXAMPLE-PG-HBA.CONF Some examples of pg_hba.conf entries are shown in Example 19-1. See the next section for details on the different authentication methods. Example 19-1. Example pg_hba.conf entries # Allow any user on the local system to connect to any database under # any user name using Unix-domain sockets (the default for local # connections). # # TYPE DATABASE USER CIDR-ADDRESS METHOD local all postgres trust The above line will allow you to connect from the command line of your postgresql server. This will get you started. I can't remember what type of connect pgadmin uses. It might be "TYPE" host. If it is you will need to add another line to the conf file for that type. Also, there is another postgres conf (I can't remember which on off the top of my head) file that will need the optional "-I" set to allow you to connect from remote IP addresses. i.e. pgadmin. If all else fails, read the help docs; the beginning sections are newbie friendly. > Should I login by this way from command line? yes