Greenplum Database File Structure
Master Data Directory
[gpadmin@sachi gpsne0]$ cd $MASTER_DATA_DIRECTORY
[gpadmin@sachi gpsne-1]$ ls
base gpperfmon pg_distributedlog pg_ident.conf pg_stat_tmp pg_twophase pg_xlog postmaster.pid
global pg_changetracking pg_distributedxidmap pg_log pg_subtrans pg_utilitymodedtmredo postgresql.conf
gp_dbid pg_clog pg_hba.conf pg_multixact pg_tblspc PG_VERSION postmaster.opts
[gpadmin@sachi gpsne-1]$ pwd
/home/gpmaster/gpsne-1
[gpadmin@sachi gpsne-1]$ ll
total 116
drwx------. 8 gpadmin gpadmin 4096 Mar 13 22:19 base
drwx------. 2 gpadmin gpadmin 4096 Mar 13 22:19 global
drwxrwxr-x. 5 gpadmin gpadmin 4096 Nov 27 12:51 gpperfmon
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_changetracking
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_clog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_distributedlog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_distributedxidmap
drwx------. 2 gpadmin gpadmin 12288 Mar 15 00:00 pg_log
drwx------. 4 gpadmin gpadmin 4096 Nov 27 12:50 pg_multixact
drwx------. 2 gpadmin gpadmin 4096 Mar 10 16:56 pg_stat_tmp
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_subtrans
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_tblspc
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:50 pg_twophase
drwx------. 2 gpadmin gpadmin 4096 Jan 18 02:15 pg_utilitymodedtmredo
drwx------. 3 gpadmin gpadmin 4096 Nov 27 12:50 pg_xlog
-rw-rw-r--. 1 gpadmin gpadmin 4751 Mar 10 16:56 pg_hba.conf
-rw-------. 1 gpadmin gpadmin 1636 Nov 27 12:50 pg_ident.conf
-rw-------. 1 gpadmin gpadmin 4 Nov 27 12:50 PG_VERSION
-r--------. 1 gpadmin gpadmin 109 Nov 27 12:51 gp_dbid
-rw-------. 1 gpadmin gpadmin 19299 Nov 27 12:51 postgresql.conf
-rw-------. 1 gpadmin gpadmin 169 Mar 10 16:56 postmaster.opts
-rw-------. 1 gpadmin gpadmin 48 Mar 10 16:56 postmaster.pid
[gpadmin@sachi gpsne-1]$
Note: 15 Directories and 7 files
Segment Data Directory
[gpadmin@sachi gpsne1]$ cd /disk1/gpdata1/gpsne0
[gpadmin@sachi gpsne0]$ ll
total 104
drwx------. 8 gpadmin gpadmin 4096 Mar 13 22:19 base
drwx------. 2 gpadmin gpadmin 4096 Mar 13 22:19 global
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_changetracking
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_clog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_distributedlog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_distributedxidmap
drwx------. 2 gpadmin gpadmin 4096 Mar 15 00:00 pg_log
drwx------. 4 gpadmin gpadmin 4096 Nov 27 12:51 pg_multixact
drwx------. 2 gpadmin gpadmin 4096 Mar 10 16:56 pg_stat_tmp
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_subtrans
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_tblspc
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_twophase
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_utilitymodedtmredo
drwx------. 3 gpadmin gpadmin 4096 Nov 27 12:51 pg_xlog
-rw-------. 1 gpadmin gpadmin 4 Nov 27 12:51 PG_VERSION
-rw-------. 1 gpadmin gpadmin 4529 Nov 27 12:54 pg_hba.conf
-rw-------. 1 gpadmin gpadmin 1636 Nov 27 12:51 pg_ident.conf
-r--------. 1 gpadmin gpadmin 109 Nov 27 12:54 gp_dbid
-rw-------. 1 gpadmin gpadmin 19205 Nov 27 12:54 postgresql.conf
-rw-------. 1 gpadmin gpadmin 158 Mar 10 16:56 postmaster.opts
-rw-------. 1 gpadmin gpadmin 47 Mar 10 16:56 postmaster.pid
[gpadmin@sachi gpsne0]$ pwd
/disk1/gpdata1/gpsne0
[gpadmin@sachi gpsne0]$ cd /disk2/gpdata2/gpsne1
[gpadmin@sachi gpsne1]$ ls -l
total 104
drwx------. 8 gpadmin gpadmin 4096 Mar 13 22:19 base
drwx------. 2 gpadmin gpadmin 4096 Mar 13 22:19 global
-r--------. 1 gpadmin gpadmin 109 Nov 27 12:54 gp_dbid
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_changetracking
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_clog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_distributedlog
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_distributedxidmap
-rw-------. 1 gpadmin gpadmin 4529 Nov 27 12:54 pg_hba.conf
-rw-------. 1 gpadmin gpadmin 1636 Nov 27 12:51 pg_ident.conf
drwx------. 2 gpadmin gpadmin 4096 Mar 15 00:00 pg_log
drwx------. 4 gpadmin gpadmin 4096 Nov 27 12:51 pg_multixact
drwx------. 2 gpadmin gpadmin 4096 Mar 10 16:56 pg_stat_tmp
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_subtrans
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_tblspc
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_twophase
drwx------. 2 gpadmin gpadmin 4096 Nov 27 12:51 pg_utilitymodedtmredo
-rw-------. 1 gpadmin gpadmin 4 Nov 27 12:51 PG_VERSION
drwx------. 3 gpadmin gpadmin 4096 Nov 27 12:51 pg_xlog
-rw-------. 1 gpadmin gpadmin 19205 Nov 27 12:54 postgresql.conf
-rw-------. 1 gpadmin gpadmin 158 Mar 10 16:56 postmaster.opts
-rw-------. 1 gpadmin gpadmin 47 Mar 10 16:56 postmaster.pid
[gpadmin@sachi gpsne1]$
Contents of PGDATA
[gpadmin@sachi gpsne-1]$ cd base
[gpadmin@sachi base]$ ls
1 10899 10900 16992 16993 33476 33553
Note: 7 Directories
sachi=# select * from pg_database;
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit | datlastsysoid | datfrozenxid | dattablespace | datconfig | datacl
-----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+------------------------------------------------------------------------
gpadmin | 10 | 6 | f | t | -1 | 10899 | 803 | 1663 | |
postgres | 10 | 6 | t | t | -1 | 10899 | 803 | 1663 | |
template1 | 10 | 6 | t | t | -1 | 10899 | 803 | 1663 | | {=c/gpadmin,gpadmin=CTc/gpadmin}
template0 | 10 | 6 | t | f | -1 | 10899 | 803 | 1663 | | {=c/gpadmin,gpadmin=CTc/gpadmin}
himanshu | 10 | 6 | f | t | -1 | 10899 | 803 | 1663 | |
sachi | 10 | 6 | f | t | -1 | 10899 | 803 | 1663 | | {=Tc/gpadmin,gpadmin=CTc/gpadmin,sachi=CTc/gpadmin,gpuser=CTc/gpadmin}
gpperfmon | 10 | 6 | f | t | -1 | 10899 | 803 | 1663 | | {gpadmin=CTc/gpadmin,=c/gpadmin}
(7 rows)
Pg_database table
System Catalogs