Home About Sciense Documentation Screenshots License Downloads Support Development

Project Page

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.



Search By Google