How to collect Greenplum DCA software (ISO) version, Greenplum Database version, and DCA serial number

posted Apr 28, 2017, 4:49 PM by Sachchida Ojha
DCA ISO version: $ cat /etc/gpdb-appliance-version
Output example:

Note 1: Only for ISO version this command uses underscrores (_) instead of dashes (-): $ cat /etc/gpdb_appliance_version

Note 2: ISO version incorrectly displays the output as The fast way to find out which version it truly is, check whether you have to use $ cat /etc/gpdb_appliance_version (ISO or $ cat /etc/gpdb-appliance-version (ISO

Greenplum Database version: # gpstate --version
Output example: gpstate version build 3

DCA serial number: # cat /opt/greenplum/serialnumber
Output example: APM00110100555

Specific postgres commands:

Query from database (Database is running): #psql postgres –c “select version();”
Output example: postgreSQL 8.2.14 (Greenplum Database build 3) on x86_64-unknown-linux-gnu, compiled by GCC gcc.exe (GCC) 4.1.1 compiled on Nov 30 2010 16:33:17

Greenplum database version (Database is not running): # postgres --gp-version
Output example: postgres (Greenplum Database) build 3

postgres engine version (Database is not running): #postgres --version
Output example: postgres (Greenplum Database) 8.2.14