Skip to main content

Steps to update eResource Scheduler hosted on Windows systems

  • Updated

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. Stop the service and move the eRS directory

Stop and remove the running eRS service and update the directory structure.

Stop-Service -Name "ers"
(Get-WmiObject -Class Win32_Service -Filter "Name='ers'").delete()
cd $env:ProgramFiles
Move-Item .\eRS\ers-self-hosted-3.1.0 -Destination .\ 
Remove-Item eRS
Rename-Item .\ers-self-hosted-3.1.0\ eRS

 

3. Add the required extension

Update the path variable to include the PSQL bin, and add the "btree_gist" extension

$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User") + ";$env:ProgramFiles\PostgreSQL\11\bin;$env:ProgramFiles\PostgreSQL\11\lib"
psql -U postgres
\c ers
CREATE EXTENSION IF NOT EXISTS btree_gist;
\q

 

4. Re-install and start eRS service

cd $env:ProgramFiles\eRS
.\bin\service\service.bat install
Start-Service -Name "ers"

 

5. Download and execute the update-script

wget https://storage.googleapis.com/app-file-store/self-hosted/files/update/update.ps1 -OutFile .\update.ps1
.\update.ps1

 

 

Related articles