Skip to main content
This article describes how to determine which PostgreSQL and PostGIS versions are installed on a server.

​
Determining the PostgreSQL version

To determine which PostgreSQL version is installed on your server, log in to your account using SSH, and then type the following command at the command line:
Alternatively, you can log in to PostgreSQL from the command line using the psql program, and then type the following query to view additional version information:

​
Determining the PostGIS version

Your server may also have PostGIS installed. To determine the version installed on your server, log in to PostgreSQL from the command line using the psql program, and then type the following query:
If PostGIS is installed, you see output that resembles the following (the exact version numbers may differ):
If PostGIS is not installed, however, you see output that resembles the following:
If you have a managed VPS or managed Dedicated server and would like PostGIS installed, please open a support ticket at https://my.hosting.com.

​
Installed PostgreSQL versions

The PostgreSQL version installed on a server depends on the operating system version:
  • Servers running AlmaLinux/Rocky Linux/CloudLinux 9 have PostgreSQL 13.18.1 installed.
  • Servers running AlmaLinux/Rocky Linux/CloudLinux 8 have PostgreSQL 10.23.4 installed.
  • Servers running CloudLinux 7 have PostgreSQL 9.6.22 installed.