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

Post date: Oct 09, 2012 5:6:13 PM

DCA ISO version: $ cat /etc/gpdb-appliance-version

Output example: 1.0.3.0

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

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

Greenplum Database version: # gpstate --version

Output example: gpstate version 4.0.4.0 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 4.0.4.0 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) 4.0.4.0 build 3

postgres engine version (Database is not running): #postgres --version

Output example: postgres (Greenplum Database) 8.2.14