Update PostgreSQL database

The PostgreSQL database is integrated with Polarion ALM. It replicates various data maintained in the Subversion repository to provide for efficient processing of highly complex queries that are better suited to SQL than Apache Lucene.

For new installations, follow the installer program or script to install the currently-recommended version of PostgreSQL. When Polarion releases a new bundled PostgreSQL version with a product update, it is necessary to update PostrgreSQL manually on Windows systems. This is because automated updating of the PostgreSQL binaries poses risk of data loss. Updates to bundled third-party software, if any, are announced in the bundled Configuration.txt file each release.

1. Stop the Polarion server, then stop PostgreSQL Service.

   (You can leave Apache Service running.)

   Tip:

   Use the shortcuts at C:\Polarion\polarion shortcuts (default path).

2. Run the update.bat script, found in the update distribution.

3. Update PostgreSQL to the version bundled in the Polarion update distribution.

   Use https://www.postgresql.org/docs/11/pgupgrade.html to upgrade your database, or just delete the directory and after installing the same PostgreSQL version as the bundled version, then use the [UPDATE]\bundled\postgres\configure_postgres.bat script to initialize a fresh database.

4. Start PostgreSQL.

   You will stop the server as part of the manual update procedure.

5. Start the Polarion server.

   Note that reindexing launches on start-up, during which all necessary data are updated in PostgreSQL.