Pivotal Knowledge Base


How to Recover a Pivotal Greenplum System when the Master Host is Rebooted


  • Pivotal Greenplum 4.3.x
  • Operating System- Red Hat Enterprise Linux 6.x


If the master is rebooted while the GPDB cluster is up, this will leave all segment instances up and be running while the master instance is down.


The following process was followed:

  1. gpstart -m  (start the master instance only)
  2. gpstop -M fast -a (once the master instance has started, shut down the whole cluster for a clean startup)
  3. gpssh -h hostfile ' ps -ef |grep post'  (ensure that no orphan process left at all hosts)
  4. gpstart -a (start the database again)
  5. Follow the directions in the article, How to run gpcheckcat on Pivotal Greenplum database to run a full gpcheckcat



Powered by Zendesk