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 5D10611F6550 for ; Tue, 28 Mar 2006 18:51:55 -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 32581-02 for ; Tue, 28 Mar 2006 18:51:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30806.mail.mud.yahoo.com (web30806.mail.mud.yahoo.com [68.142.200.149]) by postgresql.org (Postfix) with SMTP id E40C311F65E6 for ; Tue, 28 Mar 2006 18:51:52 -0400 (AST) Received: (qmail 2575 invoked by uid 60001); 28 Mar 2006 22:51:52 -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=goaWgIY0Ke6i6PulgmMj4Wm/+NyEkEmR554EHAWxUjOSKQ7Uz9J1ikAwNP6NbZ2tRYCXS52e3wzFm48n8OimzQgl55ZOiE1nUa962/AfJpqXD569JiO3An9EaNlK/rOKHsd6uDAQo8jQwsKXo9FfFjhIXRbXOX67YDv5HyM7eoM= ; Message-ID: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com> Received: from [67.175.142.230] by web30806.mail.mud.yahoo.com via HTTP; Tue, 28 Mar 2006 14:51:52 PST Date: Tue, 28 Mar 2006 14:51:52 -0800 (PST) From: lmyho Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! To: Richard Broersma Jr , pgsql-admin@postgresql.org In-Reply-To: <20060328182128.59189.qmail@web31805.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.43 required=5 tests=[AWL=0.072, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.43 X-Spam-Level: * X-Archive-Number: 200603/324 X-Sequence-Number: 21081 > > 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. > Thank you Richard!! I've made the changes and can login to the DBs through pgAdmin now!:) Really appreciated your help!!! I am starting to learn about the postgresql now.:)) >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. Seems like the pgAdmin3 uses also the Unix socket pipe. I left only the first line in the pg_hba.conf enabled as "local all postgres trust" and pgAdmin3 was able to login.:) > 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. > I am checking on this.;) If you got any more hints, please let me know. THANK YOU!!! leo __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com