Configuring from PostgreSQL Command Line Tool

Run the PostgreSQL command line client and enter following instructions:

  1. Add the tigase_user:

    psql=# create role tigase_user with login password 'tigase123';
  2. Create the database for the Tigase server with tigase_user as owner of database:

    psql=# create database tigasedb owner tigase_user;
  3. Load database schema to initialize the Tigase server from the file that corresponds to the Tigase version you want to use. First you need to switch to tigasedb.

    psql=# \connect tigasedb

    For the Tigase server version 5.0 and later you have to use proper schema version:

    psql=# \i database/postgresql-schema-5.sql

    For the Tigase server version 5.1 and later you have to use proper schema version:

    psql=# \i database/postgresql-schema-5-1.sql