You can set up a PostgreSQL database to work with
Rational® Focal Point™.
Before you begin
- A PostgreSQL database version that is supported by Rational Focal Point must
be installed. For instructions, see the PostgreSQL documentation.
- To properly handle Unicode content, the database character set
must be UTF-8 encoding.
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.
- Start the database server and create a database named focalpoint. Rational Focal Point uses
the default PostgreSQL table space.
- 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.
- 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.
- Either allow access for the database port through any
existing firewall or disable the firewall.
- Restart the database server.