X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B411A3AC02D for ; Wed, 15 Dec 2004 12:41:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81222-06 for ; Wed, 15 Dec 2004 12:41:37 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.198]) by svr1.postgresql.org (Postfix) with ESMTP id ACA283AB825 for ; Wed, 15 Dec 2004 12:41:39 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id 1so126758rny for ; Wed, 15 Dec 2004 04:41:40 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:return-path:subject:from:reply-to:to:cc:content-type:organization:date:message-id:mime-version:x-mailer; b=BdfnabGixM0SY7t36S6jr8QiaJRXRrk3eW44F9dkgO4Jw2kLxPl2exLFEtwynHYqqQ1jVVPzc8i5PC9oC7T5Xhoi0w/MidUjB9TfpyH0oobTDTmddJGAefHa2ytOL78Gxt6/zZ1uSVSgaagRkwKqzuoxn6n5s3bCYymFmOWdYq8= Received: by 10.38.179.75 with SMTP id b75mr2480630rnf; Wed, 15 Dec 2004 04:41:40 -0800 (PST) Received: from ?221.226.2.135? ([221.226.2.135]) by smtp.gmail.com with ESMTP id 62sm52187rna.2004.12.15.04.41.35; Wed, 15 Dec 2004 04:41:40 -0800 (PST) Subject: [Re]:User Admin in pgsql From: Wang Jun Reply-To: daxiawj@gmail.com To: Michael Fuhr Cc: pgsql-admin@postgresql.org Content-Type: multipart/mixed; boundary="=-AYR/66H/aqz5t84JVvqk" Organization: Nanjing Uni. Atmos. Dep. Date: Wed, 15 Dec 2004 20:42:17 +0800 Message-Id: <1103114537.8185.9.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.3 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.407 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200412/138 X-Sequence-Number: 15724 --=-AYR/66H/aqz5t84JVvqk Content-Type: text/plain Content-Transfer-Encoding: 7bit > > After I Updatded my pgsql from 7.3 to 7.4.6 in debian with > "aptitude", I > > found that my admin user account's password has gone--everytime when > I > > login into psql, I don't need type my password any more, and every > > other user account too. > > Have you looked at pg_hba.conf? See the "Client Authentication" > chapter in the documentation for details. Thanks for your help! I have modified my pg_hda.conf as the DOC said, and I can login with my password use "psql" in terminal. But it still remains a problem that I can't acess to my database through webclients such as PhpPgAdmin and my other phpclient. What's wrong then? Thank you again! -- Wang Jun@ Atmos. Dep. of Nju Nanjing Jiangsu China. GNU is Not Unix, BSD is Powerful, Ada is Beautiful, Nju is Graceful. --=-AYR/66H/aqz5t84JVvqk Content-Disposition: attachment; filename=pg_hba.conf Content-Type: text/plain; name=pg_hba.conf; charset=gbk Content-Transfer-Encoding: 7bit #This is my admin user account local all pgAdminWang password host all pgAdminWang 127.0.0.1 255.255.255.0 password host all pgAdminWang 192.168.0.114 255.255.255.0 password #this is Common user account local all wang password host all wang 127.0.0.1 255.255.255.255 password # System defaults, haven't changed yet. local all postgres ident sameuser local all all ident sameuser host all all 127.0.0.1 255.255.255.255 ident sameuser host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff ident sameuser host all all ::ffff:127.0.0.1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 reject --=-AYR/66H/aqz5t84JVvqk--