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