On Thursday 16 June 2005 10:05, Stefan Armbruster wrote:
> 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?
The nextid table is no longer used in SQLite and was never used in PostgreSQL,
so you can simply delete it from the SQLite dump.
--
Best regards,
Kern
(">
/\
V_V
-------------------------------------------------------
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
