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.
--
Bruno Friedmann
------------------------------------------------------------------------------
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
