gistfile1.txt

Setup of new server:

sudo -u postgres psql

run the following:

CREATE USER quassel ENCRYPTED PASSWORD 'somepassword';
CREATE ROLE
CREATE DATABASE quassel WITH OWNER quassel ENCODING 'UTF8';
CREATE DATABASE

Then copy the sqlite db to the configdir from the services file and run:

quasselcore --configdir=<path from servicefile> --select-backend=PostgreSQL