This article describes how to determine which PostgreSQL and PostGIS versions are installed on a server.
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:
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):
POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.9.1, released 2012/05/15 GDAL_DATA not found" LIBXML="2.7.6" TOPOLOGY RASTER (1 row)
If PostGIS is not installed, however, you see output that resembles the following:
ERROR: function postgis_full_version() does not exist
Subscribe to receive weekly cutting edge tips, strategies, and news you need to grow your web business.
No charge. Unsubscribe anytime.