You can set up a PostgreSQL database to work with Rational® Focal Point™.
Before you begin
- Install a PostgreSQL database. For instructions, see the PostgreSQL
documentation.
- To properly handle Unicode content, the database character set
must be UTF-8 encoding.
Procedure
- Create a database named focalpoint. Rational Focal Point uses the default PostgreSQL
table space.
- 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.
- Either allow access for the database port through any existing
firewall, or disable the firewall.
Note: 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 <PostgreSQL install directory>\data\pg_hba.conf file.