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 3ED7311F655D for ; Tue, 28 Mar 2006 19:54:46 -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 41173-02 for ; Tue, 28 Mar 2006 19:54:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.travelamericas.com (unknown [206.130.134.147]) by postgresql.org (Postfix) with SMTP id 8DA4611F64F4 for ; Tue, 28 Mar 2006 19:54:43 -0400 (AST) Received: (qmail 7093 invoked from network); 28 Mar 2006 23:54:42 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 28 Mar 2006 23:54:42 -0000 Message-ID: <4429CCC2.50407@travelamericas.com> Date: Tue, 28 Mar 2006 15:54:42 -0800 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: lmyho CC: Richard Broersma Jr , pgsql-admin@postgresql.org Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! References: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com> In-Reply-To: <20060328225152.2573.qmail@web30806.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.222 required=5 tests=[AWL=0.222, MANY_EXCLAMATIONS=0] X-Spam-Score: 0.222 X-Spam-Level: X-Archive-Number: 200603/327 X-Sequence-Number: 21084 lmyho wrote: > > >>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.:)) > > The authentication methods are handled between the libraries (libpq and libpxx) and the server. They are transparent to the application. identd sameuser means use the identd service to require look up the owner of the process and log him/her in accordingly. This means that you cannot change your login name but don't require a password (if you are on the DB server-- do not trust it remotely). For remote connections kerberos can be used instead, though this takes more setup and knowledge of Kerberos as a system. > > >>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.:) > > Right. But passwords are ineffective with trust authentication. If you need them you will need to use password, md5, or the like instead. Best Wishes, Chris Travers Metatron Technology Consulting