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 |
|
|