Setting up PostgreSQL databases
Perforce does not provide support for installing, configuring, or maintaining PostgreSQL. A qualified PostgreSQL database administrator should install and configure the database.
Keep the following in mind:
- Do not add, delete, or modify any fields in the Helix ALM License Server tables.
- Do not directly add, edit, or delete any data in the tables.
- Do not create different primary keys. This will adversely affect application performance.
- Do not create complex triggers on any of the tables. Triggers may cause severe database issues and correcting these issues is not covered by Perforce.
- Create a process to back up database tables on a regular schedule.
- Running PostgreSQL and the Helix ALM License Server on the same computer can result in slow performance if not configured correctly. Make sure PostgreSQL is configured correctly to avoid using all the system memory.
Creating server database tables
The Helix ALM License Server automatically creates tables in PostgreSQL when you start the server or convert the server database. The