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 8409D9DCC4C for ; Mon, 6 Mar 2006 09:02:15 -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 10425-09 for ; Mon, 6 Mar 2006 09:02:18 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web53906.mail.yahoo.com (web53906.mail.yahoo.com [206.190.36.216]) by postgresql.org (Postfix) with SMTP id 5783D9DC81D for ; Mon, 6 Mar 2006 09:02:13 -0400 (AST) Received: (qmail 54870 invoked by uid 60001); 6 Mar 2006 13:02:16 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=CmY4LEE3UfJG9bG24IT8k3m9fnKCSerI7yQsfyhYhnRP+OrJmJgflwwabS1iQLBsq44NWQCinWphqCH9QrJ11mTHUbR5RdoQyxXjP0aw6eTWRsluqwh88Ajlq3Ok/1I0uTd5RKtLcsqhvgpgzbfe5gj5TRLIzEJZhho/OajtCqU= ; Message-ID: <20060306130216.54868.qmail@web53906.mail.yahoo.com> Received: from [24.188.184.164] by web53906.mail.yahoo.com via HTTP; Mon, 06 Mar 2006 05:02:16 PST Date: Mon, 6 Mar 2006 05:02:16 -0800 (PST) From: ow Subject: pg_hba.conf + all + trust = Ident authentication failed for user "postgres" To: pgsql-admin@postgresql.org 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.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/50 X-Sequence-Number: 20807 PostgreSQL 8.1.0 on i486-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3 20051111 (prerelease) (Debian 4.0.2-4) Hi, Can't get pg_hba.conf with trust to work: testusr@test1:~$ psql -U postgres psql: FATAL: Ident authentication failed for user "postgres" If I do "su postgres" and then "psql -U postgres" then it does work. But I need testusr to be able to use psql. Installed "gidentd", rebooted psql but that did not seem to help. Any ideas? Thanks in advance -------------------------------------------------------------------------- $ cat pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust -------------------------------------------------------------------------- __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com