> Hm... with "--compatible=postgresql" the backtics get changed into '"' > characters, but the errors essentially remain the same: > > ERROR: syntax error at or near ""BaseFiles"" > LINE 1: LOCK TABLES "BaseFiles" WRITE; > ^ > ERROR: syntax error at or near "UNLOCK" > LINE 1: UNLOCK TABLES;
Postgres has a different syntax for the LOCK command, and has no UNLOCK. You can safely remove LOCK/UNLOCK commands as they're not needed in this scenario. > ERROR: relation "Client" does not exist > LINE 1: INSERT INTO "Client" VALUES (1,'diddl-fd','5.2.12 (12Sep12) ... You must create the tables before inserting data. You can either tell mysqldump to also dump the db schema (but you will have to review the CREATE TABLE statements as there are differences in type names) or create the schema using the postgres SQL script which comes with bacula. If you manage to insert all data in the new db, be sure to validate it by performing a test restore. Depending on your setup, you could also consider creating an empty database and bscanning all existing volumes into it. HTH andrea ------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122912 _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
