Skip to main content

🗄️ PostgreSQL Multi-Region Cluster

🌐 Introduction​

The PostgreSQL Multi-Region Cluster is a pre-packaged solution that automatically creates an advanced and highly available database cluster on stack models managed by the platform.

The package uses the only officially supported PostgreSQL cluster topology: Primary-Secondary.
Additionally, an extra secondary node for disaster recovery is added, resulting in the final topology:
➡️ Primary - Secondary - Secondary.

The package also includes a high availability Pgpool-II load balancer layer to:

  • Distribute requests
  • Manage PostgreSQL replication topology

🛒 Marketplace​

Find the PostgreSQL Multi-Region Cluster app (in the Clusters section or use the Search field) in the platform Marketplace.
Marketplace

⚙️ Installation​

Instalação

During installation, you will need to configure the following parameters:

  • Version – select the preferred PostgreSQL version
  • Environment – provide a name to group your cluster environments
  • Create separate environment group – check to isolate the environment group
  • PostgreSQL Regions – choose the platform regions where the clusters will be deployed.
    warning

    ⚠️ The order is important, as the first region will be the primary and the others will be secondary.

  • Pgpool-II enabled – adds load balancing, monitoring, and management node (Pgpool-II) in front of the databases in each region
  • Pgpool Regions – define the platform regions where Pgpool-II nodes will be deployed

⏳ The installation process may take a few minutes.
At the end, you will see a success window and receive emails with the entry point details and access credentials.

📊 Viewing Environments​

To view all related environments, simply switch to the environment group created during installation (example: postgres cluster).

Ambientes PostgreSQL

🔑 Cluster Access​

  • The default entry point for the multi-region cluster is the Pgpool-II leader node (deployed in the first region).
  • In case of failure, you can use any other Pgpool-II node via hostname or IP address.
  • If the client software supports multiple entry points, configure them all in a connection string to ensure automatic failover.

✅ Done! The PostgreSQL Multi-Region Cluster has been installed and is available with high availability, load balancing, and disaster recovery.

🧠 Support​

If you have questions, encounter configuration difficulties, or need help in specific situations, contact SaveinCloud technical support through the channels available on the platform dashboard.