Re: [Bacula-users] mysql- postgres conversion. Problems...

2010-03-29 Thread Alan Brown
On Fri, 26 Mar 2010, Matija Nalis wrote: have you perhaps succeded in transition from MySQL to PostgreSQL for bacula ? Eventually... An update to the documentation (or your explanation about problems and what you did) would be greately appreciated, as we're also being pinned down with

Re: [Bacula-users] mysql- postgres conversion. Problems...

2010-03-26 Thread Matija Nalis
On Sun, Mar 21, 2010 at 10:20:22PM +, Alan Brown wrote: On 21/03/10 20:43, Bruno Friedmann wrote: After moving your data from mysql to postgresql, it's important to adjust the pkey index to the correct values (last of the table) Check for each table of the db. If I remember

Re: [Bacula-users] mysql- postgres conversion. Problems...

2010-03-21 Thread Bruno Friedmann
On 03/19/2010 06:53 PM, Alan Brown wrote: bacula 5.0.1, postgres 8.1 Any ideas why I'm getting this? 9-Mar 17:47 msslay-dir JobId 6: Fatal error: sql_create.c:875 Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM (SELECT DISTINCT Name FROM batch) as a

Re: [Bacula-users] mysql- postgres conversion. Problems...

2010-03-21 Thread Alan Brown
On 21/03/10 20:43, Bruno Friedmann wrote: On 03/19/2010 06:53 PM, Alan Brown wrote: bacula 5.0.1, postgres 8.1 Any ideas why I'm getting this? 9-Mar 17:47 msslay-dir JobId 6: Fatal error: sql_create.c:875 Fill Filename table Query failed: INSERT INTO Filename (Name) SELECT a.Name FROM