Create new database user account which will be used to connect to your database:
# createuser Enter name of user to add: tigase Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y
Now using new database user account create database for your service:
# createdb -U tigase tigasedb CREATE DATABASE
Now you can load database schema:
# psql -U tigase -d tigasedb -f postgresql-schema.sql
Now database is ready for Tigase server to use it.