Help Center

Upgrade PostgreSQL Schema

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.

Upgrade Procedure

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

C:\>cd "C:\Prognosis\Server\Configuration"

Run the irpgmigrate tool from the extracted folder to configure and upgrade the PostgreSQL database to the latest version

C:\Prognosis\Server\Configuration><path-to-unzipped-upgrade>\irpgmigrate\irpgmigrate.exe "C:\Prognosis\PostgreSQL\postgres" <path-to-unzipped-upgrade>

Troubleshooting

Password Authentication Failure

- Upgrade PostgreSQL schema...

[ERROR] AssertionError [ERR_ASSERTION]: ifError got unwanted exception: password authentication failed for user "prognosis"

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.

ECONNREFUSED

- Upgrade PostgreSQL schema...

[ERROR] AssertionError [ERR_ASSERTION]: ifError got unwanted exception: connect ECONNREFUSED 127.0.0.1:5432

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.

Provide feedback on this article