Prerequisites: The person following these steps should have good knowledge of the windows command line interface and must log in with administrator privileges.
You also require Postgres super user password.
Recommended: The update process automatically creates a backup, but we strongly recommend creating a manual backup of eRS database, before proceeding.
1. Open up PowerShell with administrator privileges
2. Execute the update-script
Setup path variable:
$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User") + ";$env:ProgramFiles\PostgreSQL\11\bin;$env:ProgramFiles\PostgreSQL\11\lib;$env:ProgramFiles\PostgreSQL\17\bin;$env:ProgramFiles\PostgreSQL\17\lib"
Move to eRS installation directory:
cd $env:ProgramFiles\eRS
Run the update script:
.\update.ps1
Note: To ensure that the system is fully updated, re-run this script (.\update.ps1) until it displays the message: “The latest version is already installed.”