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 (SELECT DISTINCT Name FROM batch) as a WHERE NOT EXISTS (SELECT >> Name FROM Filename WHERE Name = a.Name): ERR=ERROR: duplicate key >> violates unique constraint "filename_pkey" >> >> Dan? >> >> >> > 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 correctly this is noted in the manual or the wiki. > > >
It's not, but I've found how to fix it. The steps given in both documents are deficient and I'll submit updates when done. ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users