If required, before a Prognosis upgrade, it may be required to upgrade the PostgreSQL database schema for internal tables that are used by various features. These include, but not limited to
- High Availability
- Call Recording Assurance
When instructed, follow these steps to upgrade the database schema. This should be performed prior to upgrading the Prognosis software otherwise it may be likely that the database will not be compatible with the newer version.
In a Prognosis HA environment, it is only required to upgrade the PostgreSQL schema on the Active server. All changes will be synchronized to the Passive server automatically.
Download the latest 'Pre-upgrade Prognosis 11.8' bundled zip file from the IR Community website by signing on and then going to 'Software → Downloads → Prognosis 11.8 Installer & Patches'
Deploy and unzip the pre-upgrade bundle into an area that is accessible from the Prognosis server.
Open an Administrative command shell on the Prognosis server
Change the current directory to be the Server → Configuration folder
Run the irpgmigrate tool from the extracted folder to configure and upgrade the PostgreSQL database to the latest version
Password Authentication Failure
If you receive this error it is because the PQL:prognosis entry in the PASSWORDS Configuration for PostgreSQL is incorrect. Re-enter the correct credentials in the PASSWORDS Configuration and try again.
If you receive this error it is because the PrognosisPostgreSQL service is stopped or the PostgreSQL port has been changed. Read Changing the PostgreSQL Port, then restart the PrognosisPostgres service and try again.