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 223B39DC833 for ; Mon, 6 Mar 2006 11:45:58 -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 42092-01 for ; Mon, 6 Mar 2006 11:46:02 -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 E60169DC810 for ; Mon, 6 Mar 2006 11:45:54 -0400 (AST) Received: (qmail 21881 invoked by uid 60001); 6 Mar 2006 15:45:59 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ctzgMTp4C1EXN9EXjSbjSUGhiEKQGeYDm69njqFEp1k2VJh4Qc7zKe3EAP6uwbjHM2iN71r0zcnpbW4R1Kx/SqjzX6iJfYFdomoMNBQ6MO34G9YVZcVXr71pdQtC7Q6Ecvsiwytz0UzPUaVTTCa3zerUEBQPCkpsjAKIhY3ZBvY= ; Message-ID: <20060306154559.21879.qmail@web53906.mail.yahoo.com> Received: from [24.188.184.164] by web53906.mail.yahoo.com via HTTP; Mon, 06 Mar 2006 07:45:58 PST Date: Mon, 6 Mar 2006 07:45:58 -0800 (PST) From: ow Subject: Re: [SOLVED] pg_hba.conf + all + trust = Ident authentication failed To: pgsql-admin@postgresql.org In-Reply-To: <20060306070336.P410@megazone.bigpanda.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.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/57 X-Sequence-Number: 20814 --- Stephan Szabo wrote: > Are you sure you're using the configuration below (ie, you're editing the I was sure... :-) > correct file and have at least used sighup after the change)? It sure > looks like the server thinks the method is ident which would be the > default for the debian packages I think. > But now I looked and, yes, in debian, the server uses config files from /etc/postgresql/8.1/main/, where it has "ident sameuser" and I was editing the files in /var/lib/postgresql/8.1/main/, my data directory. Now it works. Thanks to everyone who responded. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com