Run the PostgreSQL command line client and enter following instructions:
Add the tigase_user
:
psql=# create role tigase_user with login password 'tigase123';
Next, 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 version of Tigase you want to use.
First you need to switch to tigasedb
.
psql=# \connect tigasedb
Begin by applying the basic Schema
psql=# \i database/postgresql-common-0.0.1.sql
Continue by adding the schema files listed below:
postgresql-common-0.0.1.sql postgresql-common-0.0.2.sql postgresql-server-7.0.0.sql postgresql-server-7.1.0.sql postgresql-server-8.0.0.sql postgresql-muc-3.0.0.sql postgresql-pubsub-3.1.0.sql postgresql-pubsub-3.2.0.sql postgresql-pubsub-4.0.0.sql postgresql-http-api-2.0.0.sql
Other components may require installation such as:
postgresql-socks5-2.0.0.sql postgresql-push-1.0.0.sql postgresql-message-archiving-2.0.0.sql postgresql-unified-archive-2.0.0.sql