The OpenClinica software uses an underlying relational database management system, either PostgreSQL or Oracle. Complete these instructions if you will be using the PostgreSQL database. If you will be using the Oracle database, install Oracle instead of completing these instructions. Note: we do not provide instructions for installing Oracle.

  1. From this location http://svn.akazaresearch.com/oc/software/OpenClinica-3.1/windows/, download postgresql-8.4.7-2-windows.exe to c:ocinstall.
  2. Run:
    c:ocinstallpostgresql-8.4.7-2-windows.exe
    The     Open File Security Warning message displays.
  3. Click Run.
    The PostgreSQL Installation Wizard opens.
  4. Click Next.
    The Installation directory screen displays.
  5. Click Next to accept the default values.
    The Data directory screen displays.
  6. Click Next to accept the default values.
    The Password screen displays.
  7. Enter a password for the Postgres superuser. Record the password for use later in the installation process. Re-enter the password, and click Next.
    The Port screen displays.
  8. Click Next to accept the default value (5432).
    The Advanced Options screen displays.

    Postgres Installation - Advanced Options

  9. Complete the screen as follows:
    1. For Locale, select “Default locale”.
    2. Clear the Install pl/pgsql in template1 database? checkbox.
    3. Click Next.

    The Ready to install screen displays

  10. Click Next to start the installation.
    When the installation finishes, the Completing the PostgreSQL Setup Wizard screen displays.
  11. Clear the Launch Stackbuilder at exit checkbox, then click Finish.