2.1. PostgreSQL 8.0

2.1. PostgreSQL 8.0
Prev	Chapter 2. Database Setup	Next

Create a database with the same database name as specified in your license file.
Important
To support internationalization remember to use UNICODE option while creating database.
Check the following attributes in postgreSQL configuration.
1. tcpip_socket = true (On linux, /var/lib/pgsql/data/postgresql.conf)
2. In pg_hba.conf (On linux, /var/lib/pgsql/data/pg_hba.conf), uncomment the following
```
  local  all  all  trust 
  host   all  all  127.0.0.1  255.255.255.255 trust
                  
```
  This allows connections to the database from everywhere. If you are concerned about security, you will need to change this to allow only the machine running Celoxis to connect to this. If Celoxis is running on the same machine as the database, you only need the local entry above.
Create a database user e.g. celoxis. Grant this user all permissions on the database.
Give the above created user a password e.g. celoxis

	Important
To support internationalization remember to use `UNICODE` option while creating database.

Setting up PostgreSQL on Windows. We recommend using version 8.0.1 or above as it is the first PostgreSQL release to natively run on Microsoft Windows as a server. It can run as a Windows service. This release supports NT-based Windows releases like Win2000, XP, Win2003.