Configuring the PostgreSQL database

You can set up a PostgreSQL database to work with Rational® Focal Point™.

Before you begin

Procedure

Before you install Rational Focal Point, make sure that the following database configurations are completed. For instructions to configure the database, see the PostgreSQL documentation.

  1. Start the database server and create a database named focalpoint. Rational Focal Point uses the default PostgreSQL table space.
  2. In a dual server environment where Rational Focal Point and the database are on different servers, to connect to PostgeSQL database, you must specify the Rational Focal Point system details in the following file: PostgreSQL install directory\data\pg_hba.conf.
    1. Stop the database service and modify the required configurations file so that the focalpoint database can accept connections from the application server in which Rational Focal Point will be installed. For example, in a text editor, open the PostgreSQL install directory\data\pg_hba.conf file and add the following line: host all all IP address/32 password

      where IP address is the IP address of the application server where Rational Focal Point will be installed.

    2. Either allow access for the database port through any existing firewall or disable the firewall.
    3. Restart the database server.

Feedback