2.1. PostgreSQL 8.x

2.1. PostgreSQL 8.x
Prev	Chapter 2. Database Setup	Next

	Note
	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 localhost and from the machines on your internal network.
To 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
To 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 8.x)
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 tool
2. Open the appropriate server node
3. Right click on 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 tool
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

Prev	Up	Next
Chapter 2. Database Setup	Home	2.2. Microsoft SQL Server 2005/2008