Hi, I'm planning to migrate the catalog of a running bacula installation from sqlite to postgresql.
At first, I tried to import a sqlite dump to a freshly created postgres db. It fails at some "create table" statements. Error message is "ERROR: syntax error at or near "UNSIGNED" at character 44". My second try was to set the postgresql db with the make_pgsql_tables script shipping with bacula. The tables are set up fine. I've stripped off all "create table/index" statements of the sqlite dump so it contains only "inserts". When applying this to the db, I've got this error: ERROR: relation "nextid" does not exist So is there a recommended way to move from sqlite to postgres? Is the database sturcture identical since "nextid" table seems to exist in sqlite and not in postgresql? Regards, Stefan ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
