Let us quickly upgrade our PostgreSQL to the latest version.
From issuing select version(), was able to confirm that our current version number is PostgreSQL 11.4.
Checked online and found out that Version 11.5 is out.
- Access Vendor Website
- Review Artifacts
- Download Artifact
- Shutdown Server and Connected Clients
- Apply Artifact
- Restart PostgreSQL Service
- Audit Server
Access Vendor Website
Please go to
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads ( Link )
As of 2019-August-12th, here is the version matrix :-
Download latest artifact; as of today the latest version is 11.5
Shutdown Server and Connected Clients
Using MS Window’s Services Applet, stopped the PostgreSQL Service.
Please do same with running clients ( psql, pgAdmin4 ).
Launch installer and pretty much say Yes to all screens.
Image – Welcome
Image – Select Components
Image – Existing Installation
Image – Existing Data Directory
Image – Pre Installation Summary
Image – Ready to Install
Image – Installing
Image – Installing – Please make sure pgAdmin server is shutdown before proceeding with the upgrade
Image – Completing
Restart Service ( PostgreSQL )
Check Version Number