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 984BD14B2866 for ; Wed, 11 Aug 2004 07:41:15 -0300 (ADT) 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 35304-04 for ; Wed, 11 Aug 2004 10:41:06 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id A70CD14B281C for ; Wed, 11 Aug 2004 07:41:05 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i7BAf3iG036570 for ; Wed, 11 Aug 2004 10:41:03 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i7BAHxee029936 for pgsql-admin@postgresql.org; Wed, 11 Aug 2004 10:17:59 GMT From: "Martin J. Brown, Jr." Subject: can't authenticate pg admin User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.) Message-ID: X-Newsgroups: comp.databases.postgresql.admin MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Lines: 28 X-Complaints-To: abuse@prodigy.net Organization: SBC http://yahoo.sbc.com X-UserInfo1: SCSYQNONXRTWBS@[N[O@_WH@YR_B@EXLLBWLOOAFEQR@ETUCCNSKQFCY@TXDX_WHSVB]ZEJLSNY\^J[CUVSA_QLFC^RQHUPH[P[NRWCCMLSNPOD_ESALHUK@TDFUZHBLJ\XGKL^NXA\EVHSP[D_C^B_^JCX^W]CHBAX]POG@SSAZQ\LE[DCNMUPG_VSC@VJM Date: Wed, 11 Aug 2004 10:17:27 GMT To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=WEIRD_PORT X-Spam-Level: * X-Archive-Number: 200408/102 X-Sequence-Number: 14497 I've had this problem with 7.3.3, and now with 7.4.3. ... The pg admin is the default 'postgres'. As 'postgres', I do... postgres@localhost postgres $ 'psql -d template1' Welcome to psql 7.4.3, the PostgreSQL interactive terminal. template1=# alter user postgres password 'xyz' template1=# I exit 'psql'. I then edit 'pg_hba.conf', changing from 'trust' to 'password'. I stop, then start pg. I then do 'psql -d template1', which results in a password prompt. I enter 'xyz', and get an authentication error for user "postgres". Other db users authenticate fine, only the admin fails. Any ideas on how to fix this? -- - Martin J. Brown, Jr. - - mjbjr@mjbjr.com - Public PGP Key ID: 0x76A1778E keyserver: http://pgpkeys.mit.edu:11371/ Fingerprint: F2D2 5D2B 333F 79D0 D126 0941 21D6 7321 76A1 778E