Project

General

Profile

PostgreSQL » History » Version 8

pennywise, 05/28/2009 04:19 PM

1 1 sph
h1. PostgreSQL
2 1 sph
3 1 sph
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. 
4 1 sph
5 6 sph
For now, this is only supported in git builds.
6 6 sph
7 8 pennywise
8 8 pennywise
h2. Requirements
9 8 pennywise
10 8 pennywise
 * postgresql server version 8.3 or greater
11 8 pennywise
 * postgresql client libraries (qt4-psql)
12 1 sph
13 1 sph
h2. Preparing the database
14 1 sph
15 1 sph
We will assume you installed PostgreSQL and properly ran the initdb script.
16 1 sph
17 1 sph
Login using the database account (in my case pgsql)
18 1 sph
> <pre># su pgsql</pre>
19 1 sph
20 1 sph
Now let's create the quassel database and assign an account.
21 2 EgS
> <pre>$ psql
22 2 EgS
postgres=# CREATE USER quassel ENCRYPTED PASSWORD 'somepassword';
23 2 EgS
CREATE ROLE
24 2 EgS
postgres=# CREATE DATABASE quassel WITH OWNER quassel ENCODING 'UTF8';
25 2 EgS
CREATE DATABASE
26 1 sph
</pre>
27 1 sph
28 7 pennywise
h3. Gentoo specific
29 7 pennywise
30 7 pennywise
Read http://www.gentoo.org/doc/en/postgres-howto.xml if no postgresql-server is installed.
31 7 pennywise
To create an user and a database, just use the following:
32 7 pennywise
<pre>createuser -A -D -P -E -U postgres -W quassel
33 7 pennywise
createdb -U postgres -O quassel -E UTF8 quassel</pre>
34 7 pennywise
35 1 sph
h2. Setting up the Quassel Core
36 1 sph
37 1 sph
Now that the database is running properly, we are going to tell Quassel to use the correct backend.
38 1 sph
Use one of the two steps below and you're done!
39 1 sph
40 1 sph
h3. For a new core
41 1 sph
42 2 EgS
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.
43 1 sph
44 1 sph
h3. To migrate an existing core
45 1 sph
46 5 sph
Make sure the core is not running and then execute the following:
47 4 sph
48 3 EgS
> <pre>$ quasselcore --select-backend=PostgreSQL</pre>
49 1 sph
50 1 sph
An interactive script will request the necessary information to migrate successfully.