Document for minor PostgreSQL Client updates. (ex. Postgresql 16.3 > Postgresql 16.4)

**Important: this is to be completed on your Web Server, not Database Server **

If you are unsure, please contact Genesis Support for assistance.

Overview of PostgreSQL Client Upgrade

1. Shutdown Apache Tomcat services
2. Uninstall the current PostgreSQL Client
3. Install New PostgreSQL Client
4. Update Environment Variables
5. Verify Installation
6. Start Apache Tomcat

1. Stop running Tomcat processes:

• First, you will want to shut down Apache Tomcat services.

• Open services.msc > Stop service “Apache Tomcat” and “SchoolFi” (if they are hosted on the same server)

  If the services cannot shut down, open a CMD Prompt window. Run as an administrator and run these commands.

  taskkill /f /im tomcat10.exe

  taskkill /f /im schoolfi.exe

2. Uninstall the current PostgreSQL Client 

**It is crucial not to perform this step on the Database Server, only on the Web Server. If performed on the Database Server, then data loss can happen.** 

If you are unsure, please contact Genesis Support for assistance.

• Open Control Panel > Uninstall a program

• Uninstall PostgreSQL 16

3. Install new PostgreSQL Client: 

• Download the latest PostgreSQL installer.
  • EBS Website: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
• Double-click to run the PostgreSQL 16.4 installer
  • Click Next to begin

• Choose the same disk drive as the one used by the previous PostgreSQL Client. X:\PostgreSQL\16
• Click Next

• Uncheck PostgreSQL Server, pgAdmin 4, and Stack Builder on the Select Components screen:
• Click Next

• Click Next

• Click Next

• Click Finish

4. Update Environment Variables:

Now that the new PostgreSQL Client is installed on the server, we need to configure environment variables.

The following screen can usually be found by right-clicking on  This PC (My Computer) and selecting Properties.

Go to the Advanced System Settings area, and then click on the Environment Variables button. 

The following screen shots are from Windows 11 and may differ slightly in other versions of Windows.

In the System Variables section, click New 

Variable name: Path

Variable Value: C:\PostgreSQL\16\bin 

5. Verify Installation:

• Command Line, psql –version to verify the PostgreSQL installation

6. Start Apache Tomcat

• Open services.msc > Start service “Apache Tomcat” and “SchoolFi”

• Or from CMD Prompt > Run as administrator, execute these commands:

  • Genesis
    • net start tomcat10 
  • Schoolfi
    • net start schoolfi