Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 2A2972E005D for ; Sun, 30 Mar 2008 17:36:21 -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 79957-03 for ; Sun, 30 Mar 2008 17:36:16 -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 9DCEC2E004D for ; Sun, 30 Mar 2008 17:36:20 -0300 (ADT) Received: from [192.168.1.8] (unknown [192.168.1.8]) by collab.sm-wg.net (Postfix) with ESMTP id EAEB5180E08 for ; Sun, 30 Mar 2008 21:36:18 +0100 (IST) Message-ID: <47EFF9C2.4010401@sm-wg.net> Date: Sun, 30 Mar 2008 21:36:18 +0100 From: Bernhard D Rohrer User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: bacula problem - failures with no error message in postgres? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200803/263 X-Sequence-Number: 28746 hiya I know this is somewhat offtopic, but I am stuck. I am trying to get bacula to run and am testing the backup catalog script. I am using postgres for my database and am getting this error 30-Mar 19:33 collab-dir: BackupCatalog.2008-03-30_19.33.00 Fatal error: sql_create.c:485 sql_create.c:485 query SELECT ClientId,Uname FROM Client WHERE Name='collab-fd' failed: 30-Mar 19:33 collab-dir: BackupCatalog.2008-03-30_19.33.00 Fatal error: sql_create.c:520 sql_create.c:520 insert INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('collab-fd','',1,2592000,15552000) failed: 30-Mar 19:33 collab-dir: BackupCatalog.2008-03-30_19.33.00 Error: sql_create.c:522 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('collab-fd','',1,2592000,15552000) failed. ERR= 30-Mar 19:33 collab-dir: BackupCatalog.2008-03-30_19.33.00 Fatal error: Could not create Client record. ERR=sql_create.c:522 Create DB Client record INSERT INTO Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES ('collab-fd','',1,2592000,15552000) failed. ERR= even on the higher debug levels I am not seeing thing in the postgres logs any ideas? Thanks a lot Bernhard -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net -- Graylion's Fetish & Fashion Store Goth and Kinky Boots, Clothing and Jewellery http://www.graylion.net