Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 5F2672E0035 for ; Sun, 30 Mar 2008 14:03:17 -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 27584-08 for ; Sun, 30 Mar 2008 14:03:15 -0300 (ADT) X-Greylist: delayed 00:06:51.775226 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 DCE1F2E002F for ; Sun, 30 Mar 2008 14:03:16 -0300 (ADT) Received: from [192.168.1.8] (unknown [192.168.1.8]) by collab.sm-wg.net (Postfix) with ESMTP id 24922180DE8 for ; Sun, 30 Mar 2008 17:56:23 +0100 (IST) Message-ID: <47EFC636.6070506@sm-wg.net> Date: Sun, 30 Mar 2008 17:56:22 +0100 From: Bernhard D Rohrer User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: local authentication with md5 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200803/257 X-Sequence-Number: 28740 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 -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net