BestHub
search
Sign in
Tag

gpstate

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 30, 2023 · Databases

Greenplum Segment Failure Diagnosis and Recovery Procedures

This article explains how to simulate and diagnose segment failures in a Greenplum cluster, including identifying master, segment, and tablespace issues, generating recovery configuration files, and using gprecoverseg and gpstate commands to restore segment roles and ensure all nodes are operational.

Database RecoveryGreenplumSegment Failure
0 likes · 24 min read
Greenplum Segment Failure Diagnosis and Recovery Procedures
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 28, 2022 · Databases

Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure

This article describes the background, architecture, and a detailed troubleshooting process for restoring a mistakenly deleted Greenplum standby data directory, including status checks, configuration cleanup, standby initialization, verification commands, and additional recommendations for handling master failures in a distributed database cluster.

Database AdministrationDistributed DatabaseGreenplum
0 likes · 10 min read
Recovering a Deleted Greenplum Standby Node: Analysis and Step‑by‑Step Procedure