Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 83C042E0070 for ; Sun, 30 Mar 2008 16:24:06 -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 65143-06 for ; Sun, 30 Mar 2008 16:24:02 -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 0F2F82E006D for ; Sun, 30 Mar 2008 16:24:06 -0300 (ADT) Received: from [192.168.1.8] (unknown [192.168.1.8]) by collab.sm-wg.net (Postfix) with ESMTP id 6BD71180DFC for ; Sun, 30 Mar 2008 20:24:04 +0100 (IST) Message-ID: <47EFE8D4.2010606@sm-wg.net> Date: Sun, 30 Mar 2008 20:24:04 +0100 From: Bernhard D Rohrer User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: local authentication with md5 - solved References: <47EFC636.6070506@sm-wg.net> In-Reply-To: <47EFC636.6070506@sm-wg.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200803/259 X-Sequence-Number: 28742 Bernhard D Rohrer wrote: > Hi all > > I have set my authentication to > > # "local" is for Unix domain socket connections only > local all all md5 #ident sameuser > > for security reasons > > this leads to this problem when trying to run a script: > > 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" > > how does one pass an md5 encrypted pw to postgres? I tried it with > clear as well, but that failed too. Not happy doing that anyway. > > many thanks in advance > > Bernhard > sorted, thanks! -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net