Dear Andrea,
thanks for your help.
In message <50DEB974.1070709 AT alyf DOT net> you wrote:
> > 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.
It appears there are more differences...
> > 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.
I did create the tables before - I followed the instructions and ran
the commands
./drop_bacula_tables
./make_bacula_tables
./grant_bacula_privileges
before attempting the DB import.
> Depending on your setup, you could also consider creating an empty
> database and bscanning all existing volumes into it.
This is not really an option for me. I have >700 tapes (including a
large number of old, slow SLR100 and DDS-3 tapes) in 2 databases.
Scanning these tapes would take ages and cause a significant amount of
manual interaction.
Best regards,
Wolfgang Denk
--
DENX Software Engineering GmbH, MD: Wolfgang Denk & Detlev Zundel
HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
"It is better for civilization to be going down the drain than to be
coming up it." - Henry Allen
------------------------------------------------------------------------------
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. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_123012
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|