Installing AlekSIS with PostgreSQL backend¶

PostgreSQL is the only supported database backend for AlekSIS. If you are installing AlekSIS manually, you need to properly set it up.

Install the PostgreSQL server¶

On Debian, install the postgresql server package with:

sudo apt install postgresql

On Debian, you can use the following commands to create the database and a user who owns it:

sudo -u postgres createuser -D -P -R -S aleksis
sudo -u postgres createdb -E UTF-8 -O aleksis -T template0 -l C.UTF-8 aleksis

When asked for the database user password, choose a secure, preferrably random, password. You can generate one using the pwgen utility if you like:

pwgen 16 1

Fill in the configuration under /etc/aleksis/aleksis.toml (or a file with any other name in this directory):

[database]
host = "localhost"
name = "aleksis"
username = "aleksis"
password = "Y0urV3ryR4nd0mP4ssw0rd"

Don’t forget to run the migrations, like described in the basic setup guide.