Run the PostgreSQL command line client and enter following instructions:
-
Add the tigase_user:
psql=# create role tigase_user with login password 'tigase123';
-
Create the database for the Tigase server with tigase_user as owner of database:
psql=# create database tigasedb owner tigase_user;
-
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