Migrate from SQLite to PostgreSQL

Shutdown Lutim to avoid URL creation while migrating.

Install some dependencies:

apt-get install sqlite3 libsqlite3-mod-impexp
sqlite3 /var/www/lutim/lutim.db

In SQLite prompt, do this to export data:

.load libsqlite3_mod_impexp
SELECT export_sql('/tmp/lutim.sql','1');
.exit

Modify the exported file (the export format is close to PostgreSQL's SQL but not quite):

sed -e "s@^INSERT OR REPLACE @INSERT @" -e 's@INSERT INTO "mojo_migrations".*@@' -i /tmp/lutim.sql

Create PostgreSQL database:

su - postgres
createuser lutim_user -P
createdb -O lutim_user lutim_db

Configure Lutim to use PostgreSQL and start it to create the database structure.

Then import the data:

su postgres
psql lutim_db < /tmp/lutim.sql