Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id E29C02E006D for ; Sun, 30 Mar 2008 16:34:28 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 66813-06 for ; Sun, 30 Mar 2008 16:34:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from collab.sm-wg.net (87-198-254-6.ptr.magnet.ie [87.198.254.6]) by developer.postgresql.org (Postfix) with ESMTP id 3AE952E0046 for ; Sun, 30 Mar 2008 16:34:28 -0300 (ADT) Received: from [192.168.1.8] (unknown [192.168.1.8]) by collab.sm-wg.net (Postfix) with ESMTP id 90BB7180DFD; Sun, 30 Mar 2008 20:34:26 +0100 (IST) Message-ID: <47EFEB42.6000402@sm-wg.net> Date: Sun, 30 Mar 2008 20:34:26 +0100 From: Bernhard D Rohrer User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: local authentication with md5 References: <47EFC636.6070506@sm-wg.net> <27348.1206905555@sss.pgh.pa.us> In-Reply-To: <27348.1206905555@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200803/262 X-Sequence-Number: 28745 Tom Lane wrote: > Bernhard D Rohrer writes: >> I have set my authentication to >> # "local" is for Unix domain socket connections only >> local all all md5 #ident sameuser > > Are you sure this actually took effect (ie did you "pg_ctl reload")? > >> 30-Mar 17:47 collab-dir: BeforeJob: run command >> "/etc/bacula/scripts/make_catalog_backup bacula postgres >> 'md5xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx'" >> 30-Mar 17:47 collab-dir: BeforeJob: pg_dump: [archiver (db)] connection >> to database "bacula" failed: FATAL: Ident authentication failed for user >> "postgres" > > It's clear that this connection is trying to use ident not md5. > Either you didn't make the pg_hba edit take effect, or bacula > is trying to use TCP instead of Unix-socket connection and you > still have the "host" line set to ident. > > regards, tom lane The bizarre thing is that removing #ident sameuser solved it clearly the # is not parsed correctly after a statement cheers Bernhard -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net