Installing the Greenplum High Availability Service

This section provides guidance on how to install the Greenplum high availability service, called the greenplum-postmaster service. The greenplum-postmaster service monitors the primary segments of a Greenplum cluster to initiate automatic recovery if they become unavailable. This is required if running Greenplum without mirroring. Refer to About the Greenplum Architecture for more information about Greenplum primary segments and mirroring.

Note

This section is not applicable if you deployed a mirrorless Greenplum cluster using the Greenplum Virtual Appliance, since the greenplum-postmaster service is already included and enabled by default. Visit Managing the High Availability Service for Mirrorless Greenplum for more details.

Prerequisites

Ensure you meet the following prerequisites to install the greenplum-postmaster service:

• You have initialized a Greenplum Database cluster version 6 or above and it is running on a Supported Platform.

• You have downloaded the Greenplum Virtual Service RPM from Broadcom Support Portal under the desired Greenplum release.

  Note

  For more information about download prerequisites, troubleshooting, and instructions, see Download Broadcom products and software.

  Note

  The Greenplum Virtual Service RPM contains a collection of binaries and services to help with Greenplum virtualization. To install the high availablility service, you use the binary postmaster-service-initialize.

Installing the Greenplum Virtual Service RPM

1. Copy the Greenplum Virtual Service RPM to the coordinator host.

   scp greenplum-virtual-service-*.rpm root@cdw:/tmp
   

2. Log in to the coordinator as root and install Greenplum Virtual Service RPM on all the hosts using the gpsync and gpssh commands.

   source /usr/local/greenplum-db/greenplum_path.sh
   gpsync -f /home/gpadmin/hosts-all /tmp/greenplum-virtual-service-*.rpm =:/tmp
   gpssh -f /home/gpadmin/hosts-all -e "dnf install -y /tmp/greenplum-virtual-service-*.rpm"
   

3. Verify that the greenplum-postmaster-service binaries are installed:

   gpssh -f /home/gpadmin/hosts-all -e "ls -l /etc/gpv/greenplum-postmaster-service"
   

Initializing the greenplum-postmaster Service

1. Log in to the coordinator as gpadmin user.

2. Make sure the Greenplum database is running:

   gpstate
   

3. To initialize postmaster service using the default port (5432), run:

   /etc/gpv/postmaster-service-initialize
   

4. To initialize postmaster service using a custom port (for example, 6543), run:

   /etc/gpv/postmaster-service-initialize --port 6543
   

5. On successful completion, postmaster.service starts on all hosts.

Next Steps

Refer to Managing the High Availability Service for Mirrorless Greenplum for details on how to manage the service.