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 5009C11F6538 for ; Tue, 28 Mar 2006 20:39:29 -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 44727-06 for ; Tue, 28 Mar 2006 20:39:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30802.mail.mud.yahoo.com (web30802.mail.mud.yahoo.com [68.142.200.145]) by postgresql.org (Postfix) with SMTP id 1C2E511F6547 for ; Tue, 28 Mar 2006 20:39:26 -0400 (AST) Received: (qmail 12193 invoked by uid 60001); 29 Mar 2006 00:39:26 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=2tLy7UGzFji6kuxR4mMOjHYeknr2euKQ6NRyH6oCK6oHrz/Cncxo4pUboIWijTI+QhPmhdO+jeqmuwdAwwFpJq8YSnu56xeQGMSD8rWZA2s/L6wYQ0bOD4ypLaGnOjAbMRC325AY0/6+Twni9mdSkBERd2XeoZ6QGki3amqbFYM= ; Message-ID: <20060329003926.12191.qmail@web30802.mail.mud.yahoo.com> Received: from [67.175.142.230] by web30802.mail.mud.yahoo.com via HTTP; Tue, 28 Mar 2006 16:39:26 PST Date: Tue, 28 Mar 2006 16:39:26 -0800 (PST) From: lmyho Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! To: Chris Travers Cc: pgsql-admin@postgresql.org In-Reply-To: <4429CCC2.50407@travelamericas.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.333 required=5 tests=[AWL=-0.025, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.333 X-Spam-Level: * X-Archive-Number: 200603/328 X-Sequence-Number: 21085 > > > > > >>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): > > > >>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. Thank you for this knowledge too!! So appreciated! otherwise I may end up with my trust and passwd setting and going to real work!:( wish the doc mentioned it as well. Very kind regards, leo __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com