Node management

All data nodes in a PGD cluster are members of one or more groups. By default, all data nodes are members of the top-level group, which spans all data nodes in the PGD cluster. Nodes can also belong to subgroups that can be configured to reflect logical or geographical organization of the PGD cluster.

You can manage nodes and groups using the various options available with nodes and subgroups.

• Creating PGD nodes covers the steps needed to create a new node in a PGD cluster.

• Groups and subgroups goes into more detail on how groups and subgroups work in PGD.

• Creating and joining PGD groups looks at how new PGD groups can be created and how to join PGD nodes to them.

• Viewing PGD topology details commands and SQL queries that can show the structure of a PGD cluster’s nodes and groups.

• Removing nodes and groups shows the process to follow to safely remove a node from a group or a group from a cluster.

• Node restart and down node recovery details the steps needed to bring a node back into service after a failure or scheduled downtime and the impact it has on the cluster as it returns.

• Relationship to automatic synchronization looks at how the automatic sync feature works in PGD and how it can be used to keep nodes in sync with each other.

• Node UUIDs explains how the UUIDs of nodes are used in PGD and how they are generated.

• Replication slots created by PGD examines how the Postgres replication slots are consumed when PGD is operating.

• Creating PGD nodes
  • It’s just Postgres
  • Which Postgres version?
  • Installing Postgres
  • Installing the BDR extension
    • Configuring the database for PGD
  • Setting up the replicated database
  • Next steps
• Groups and subgroups
  • Groups
  • Sub-groups
    • Configuring per-subgroup connection strings
• Creating and joining PGD groups
  • Creating and joining PGD groups
• Viewing PGD topology
  • Listing PGD groups
    • Using pgd-cli
    • Using SQL
  • Listing nodes in a PGD group
    • Using pgd-cli
    • Using SQL
• Removing nodes and groups
  • Removing a node from a PGD group
  • Automatically evicting lagging nodes
  • Removing a whole PGD group
• Node restart and down node recovery
• Automatic synchronization
  • Auto-triggering the Sync
  • Cancellation
  • Sync Request Life Cycle
  • GUC
• Node UUIDs
  • Why UUIDs?
  • How are UUIDs generated?
  • What happens if a node is removed and a replacement added?
  • UUID-related changes in PGD 6
• Replication slots created by PGD
  • Other slot names