Skip to main content
Celoxis 2026.2 is live — portfolio scenarios, LEX AI answers, faster dashboards. See what's new
EN
Knowledge Basev12.0

Setting up your Database

Celoxis requires a database to store data. The database must be configured before you start the installation process. Sample instructions for each software is given below. Instructions are based on the default settings and often vary from version to version and from platform to platform. It is not feasible for us to cover all cases so please consult your database administrator for any setup, security or performance questions. Creating and configuring databases is beyond the scope of our support services.

In a nutshell, Celoxis needs a database instance and a privileged database user account that create, query, modify, and delete tables, indices, contraints, etc. and their definitions. We recommend that you do not share the database instance and this database with any other application.

  1. Allow Postgresql to accept TCP/IP connections:
    1. Open postgresql.conf. On Linux, you can find it most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdminFilepostgresql.conf.
    2. Uncomment the line (if not already) listen_addresses = '*' i.e. it should not have # as the prefix.
    3. Save the file and exit.
  2. Allow connections from your local network:
    1. Open pg_hba.conf On Linux, you can find it most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdminFilepg_hba.conf.
    2. Assuming your network address is 192.168.0.0 and network mask is 255.255.255.0, add the following lines to that file. If Celoxis will be running on the same server as your Postgresql server, then you only need the first line below. local all all trust host all all 127.0.0.1 255.255.255.255 trust host all all 192.168.0.0 255.255.255.0 trust
    3. Save the file and exit.
    4. Restart Postgresql. (On Linux, run: sudo service postgresql restart, while on Microsoft Windows choose Stop service and then Start service from All Programs > Postgresql
  3. Create a database user with name celoxis with a password. Note this down, you will be asked for this during installation.

    Use the createuser command as shown below:

    $ createuser celoxis
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
CREATE ROLE
$
  4. Create a database with UNICODE character encoding with celoxis as its owner. The database name should be the same as specified in your license request.

    Use the createdb command as shown below:

    $ createdb -E UNICODE -U celoxis celoxis
CREATE DATABASE
$