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)
      1. 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. You should now have an "OSEE" Database under Databases
    5. Click on OSEE and then expand it and expand Schemas
      1. Create the "osee" schema:
        1. Right click on Schemas and select "New Schema..."
        2. Enter the following in the dialog:
              Name: osee
              Owner: osee
        3. Click 'OK'
        4. You should now have an "osee" schema under schemas
      2. The relational database is now configured. Proceed to OSEE Database Initialization