OSEE - PostgreSQL Installation

Pre-Requisites

• Ensure you have selected the best database for your needs

Instructions

1. Download PostgreSQL from http://www.postgresql.org/download
2. Follow PostgreSQL installation instructions

3. By default, the PostgreSQL database server is configured to allow only local connections. If remote connections are to be allow, edit postgresql.conf and pg_hba.conf to set the necessary permissions. (To setup an unsecured database instance set listen_address to * in the postgresql.conf file and add the following line to the pg_hba.conf file: host  all  all  0.0.0.0/0  trust)

4. Configure PostgreSQL for OSEE
   1. Launch pgAdmin (in windows Start->All Programs->PostgreSQL*->pgAdmin III)
   2. Double Click on PostgreSQL Database Server (listed under Servers on the left hand side) If you are prompted for a password type the password selected during installation (user should be postgres by default)
      
   3. Create an "osee" user
      1. Right-click on Login Roles (at the bottom of the tree on the left hand side) and select "New Login Role..."
      2. Enter the following in the dialog:

         Role Name: osee
         Can login should be checked
         Password: osee
         Password (again): osee
         For Role Priviledges - select the following:
             Inherits rights from parent roles
             Superuser
             Can create database objects
             Can modify catalog directly
         

      3. Click 'OK'
      4. You should now have an "osee" user under Login Roles
   4. Expand the Databases item in the tree
   1. Create the OSEE database right-clicking on Databases and selecting "New Database..."
   2. Enter the following in the dialog:
          Name: osee
          Owner: osee
          Encoding: UTF-8
   3. Click 'OK'
   4. Ensure there is now an "osee" Database under Databases
5. The relational database is now configured. Proceed to OSEE Database Initialization