To create the data directory location on the master

The data directory location on the master is different than those on the segments. The master does not store any user data, only the system catalog tables and system metadata are stored on the master instance, therefore you do not need to designate as much storage space as on the segments.

1. Create or choose a directory that will serve as your master data storage area. This directory should have sufficient disk space for your data and be owned by the gpadmin user and group. For example, run the following commands as root:

   # mkdir -p /data/master

2. Change ownership of this directory to the gpadmin user. For example:

   # chown gpadmin:gpadmin /data/master

3. Using gpssh, create the master data directory location on your standby master as well. For example:

   # source /usr/local/greenplum-db/greenplum_path.sh 
   # gpssh -h smdw -e 'mkdir -p /data/master'
   # gpssh -h smdw -e 'chown gpadmin:gpadmin /data/master'

To create the data directory locations on all segment hosts

1. On the master host, log in as root:

   # su

2. Create a file called hostfile_gpssh_segonly. This file should have only one machine configured host name for each segment host. For example, if you have three segment hosts:

   sdw1
   sdw2
   sdw3

3. Using gpssh, create the primary and mirror data directory locations on all segment hosts at once using the hostfile_gpssh_segonly file you just created. For example:

   # source /usr/local/greenplum-db/greenplum_path.sh 
   # gpssh -f hostfile_gpssh_segonly -e 'mkdir -p /data/primary'
   # gpssh -f hostfile_gpssh_segonly -e 'mkdir -p /data/mirror'
   # gpssh -f hostfile_gpssh_segonly -e 'chown -R gpadmin /data/*'