PostgreSQL » History » Version 8
This article describes how you can use Quassel with the PostgreSQL database. It is written from a FreeBSD point of view, but the process should be very similar for any other system out there.
For now, this is only supported in git builds.
- postgresql server version 8.3 or greater
- postgresql client libraries (qt4-psql)
Preparing the database¶
We will assume you installed PostgreSQL and properly ran the initdb script.
Login using the database account (in my case pgsql)
# su pgsql
Now let's create the quassel database and assign an account.
$ psql postgres=# CREATE USER quassel ENCRYPTED PASSWORD 'somepassword'; CREATE ROLE postgres=# CREATE DATABASE quassel WITH OWNER quassel ENCODING 'UTF8'; CREATE DATABASE
Read http://www.gentoo.org/doc/en/postgres-howto.xml if no postgresql-server is installed.
To create an user and a database, just use the following:
createuser -A -D -P -E -U postgres -W quassel createdb -U postgres -O quassel -E UTF8 quassel
Setting up the Quassel Core¶
Now that the database is running properly, we are going to tell Quassel to use the correct backend.
Use one of the two steps below and you're done!
For a new core¶
Just connect to the core using a Quassel Client to launch the first run wizard. Select the PostgreSQL backend in the dropdown list and fill in the needed credentials to connect to the Postgres DB you just created.
To migrate an existing core¶
Make sure the core is not running and then execute the following:
$ quasselcore --select-backend=PostgreSQL
An interactive script will request the necessary information to migrate successfully.