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 1F09011F645C for ; Tue, 28 Mar 2006 22:56:18 -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 71315-01 for ; Tue, 28 Mar 2006 22:56:18 -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 9A05711F628B for ; Tue, 28 Mar 2006 22:56:15 -0400 (AST) Received: (qmail 19339 invoked from network); 29 Mar 2006 02:55:42 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 29 Mar 2006 02:55:42 -0000 Message-ID: <4429F72D.5050309@travelamericas.com> Date: Tue, 28 Mar 2006 18:55:41 -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: Chris Travers , pgsql-admin@postgresql.org Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! References: <20060329003926.12191.qmail@web30802.mail.mud.yahoo.com> In-Reply-To: <20060329003926.12191.qmail@web30802.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.209 required=5 tests=[AWL=0.209, MANY_EXCLAMATIONS=0] X-Spam-Score: 0.209 X-Spam-Level: X-Archive-Number: 200603/331 X-Sequence-Number: 21088 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. >>>> >>>> >>>> >>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. >> >> >> >Really thank you Chris!! I really don't know these.:( Forgot what I tried last >night, but I ke[t using user postgres to try everytime as I was trying to login as >an admin user. So here you mean actually with the "ident sameuser", the other >username can also login if the access is issued from the user's own process? (not >sure how should I state it correctly, but hope you know what I mean): > > Perhaps I wasn't clear. With identd authentication a username is still specified. But you have to own the process to login with that username. So generally speaking (absent sudo and the like) you can generally login only with the same username as your OS username. The documentation of PostgreSQL goes into a bit of depth on authentication, but if you want a little bit to get started, you might find the following article helpful: http://www.metatrontech.com/sql-ledger-wiki/index.php?UnderstandingPostgreSQLAuthentication Best Wishes, Chris Travers Metatron Technology Consulting