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-27 Thread Bruno Friedmann
On 03/26/2010 12:46 PM, Matija Nalis wrote: > > 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) >

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 r

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

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