Configuring PostgreSQL

In the case of PostgreSQL there are 2 important things to configure; the first is to create the database for ScienSe, and the second is to allow connections JDBC from ScienSe to PostgreSQL.

Setting Up PostgreSQL:

1. If you already have databases working in your system that allow JDBC connections go to the next point. In other case continue to the next interjection.
   
   
2. adduser postgres.
   
   
3. mkdir /var/lib/pgsql/data
   
   
4. chown postgres /var/lib/pgsql/data
   
   
5. su - postgres
   
   
6. initdb -D /var/lib/pgsql/data
   
   
7. postmaster -D /var/lib/pgsql/data > logfile 2 > & 1 &
   
   
8. createdb test
   
   

Allowing JDBC connections

1. In the file postgresql.conf to add the line: tcpip_socket = true
   
   
2. In the file pg_hba.conf to add the line:
   
   host all all ip_server net_mask trust
   
   where to ip_server is the IP direction of the server where is tomcat and net_mask is the net mask.