PostgreSQL 9.x

The instructions are for example only, please talk to your database and system administrator to secure your database server.

First ensure that your PostgreSQL server is accepting TCP/IP connections from local host and from the machines on your internal network.

Enable TCP/IP connections
1. Edit postgresql.conf (On Linux, this will be most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdmin's File > Open postgresql.conf...
2. Search for Connection Settings.
3. Uncomment the line (if not already) listen_addresses = '*' i.e. it should not have # as the prefix.
4. Save the file and exit.
Allow connections from your local network:
Assuming your network address is 192.168.0.0 and network mask is 255.255.255.0
1. Edit pg_hba.conf (On Linux, this will be most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdmin's File > Open pg_hba.conf...)
2. 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.
  Once you do the above changes, restart Postgresql. (On Linux, as root, type : /etc/init.d/postgresql restart and on Microsoft Windows choose Stop service and then Start service from All Programs > Postgresql)
Create a database user with name celoxis with a password. Note this down, you will be asked for this during installation.
On Linux, to create a user, 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
$
```
On Microsoft Windows:
1. Open pgAdmin program.
2. Open the appropriate server node.
3. Right click Login Roles and choose New Login Role...
4. Enter celoxis as the Role name and optionally enter a password. Ensure that Account expires is empty.
5. Select the Can create database objects option from Role Privileges.
6. Click OK.
Create a database with UNICODE (or UTF8) character encoding where owner is the user celoxis. The database name should be the same as specified in your license request.
On Linux, to create a database with name celoxis, use the createdb command as shown below:
```
$ createdb -E UNICODE -U celoxis celoxis
CREATE DATABASE
$
```
On Microsoft Windows:
1. Open pgAdmin program.
2. Open the appropriate server node.
3. Right click on the Databases node and choose New Database...
4. Enter the correct database name, pick celoxis as the owner and choose UTF8 as the encoding.
5. Click OK.