PostgreSQL Minor Updates

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

1. Stop running processes (Tomcat / Postgresql):

• Go to Services by typing services in the window search.
• Navigate the list of services and find:
  1. Apache Tomcat – may be called schoolfi
  2. Postgresql-x64-version (postgresql-x64-16)
• Select each service and click ‘Stop the service’ on the left side.

Install new PostgreSQL: 

• Download 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

• Uncheck Stack Builder on the Select Components screen:

• Click Next

• Click Next

• Click Next

• Click Next to begin the installation

• The installation is started, a popup may appear to shutdown the pgAdmin server, just click OK

• Click Next to finish the installation.

Verify Installation:

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

• Restart the server.
• When the server comes back up, verify the Apache Tomcat and postgresql services are running.
  1. If the services are not running, from command line type: net start service_name (where service_name = Apache Tomcat10/schoolfi/postgresql-x64-16)