Problem with bacula and 8.3/8.4 - Mailing list pgsql-general

From Arturo Pérez
Subject Problem with bacula and 8.3/8.4
Date
Msg-id A2AE4B0E-F13D-4920-9F9D-7434A1817CBD@ethicist.net
Whole thread Raw
Responses Re: Problem with bacula and 8.3/8.4
List pgsql-general
Hi all,

I've tried, in various combinations, bacula (2.4, 3.0) and pgsql 8.4
and 8.3 in an upgrade attempt.  Whichever combo I try I get the
following error:

19-Aug 02:24 bacula-dir JobId 1951: Fatal error: sql_create.c:789
Fill Path table Query failed: INSERT INTO Path (Path) SELECT a.Path
FROM (SELECT DISTINCT Path FROM batch) AS a WHERE NOT EXISTS (SELECT
Path FROM Path WHERE Path = a.Path) : ERR=ERROR:  array size exceeds
the maximum allowed (268435455)

Batch is a temp table so I tried bumping temp_buffers up to 268MB but
I still got the error.  Anything I else I should try before I
rollback the upgrade?

tia,
arturo


pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Wich the best way to control the logic of a web application?
Next
From: Clemens Schwaighofer
Date:
Subject: Re: Postgre RAISE NOTICE and PHP