Skip to main content

OSEE - PostgreSQL Installation


  • Ensure you have selected the best database for your needs


  1. Download PostgreSQL from
  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  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
            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

Back to the top