PostgreSQL Multi-Region Cluster Setup

The PostgreSQL Multi-Region Cluster is a ready-to-use solution that sets up a robust database system automatically using platform tools. It uses a Primary-Secondary configuration with an extra secondary node for backup, ensuring reliability.

To boost availability, it also includes a Pgpool-II Load Balancer. This tool spreads out requests and manages data replication across different regions. This setup ensures your database stays accessible, even if one region has issues.

From the marketplace, choose the PostgreSQL Multi-Region Cluster application.

In the installation window, you’ll set up your PostgreSQL database cluster by choosing the version you prefer.

Give your cluster environment a name for easy identification, and check the box to keep it separate if needed.

Select platform regions where your cluster will be deployed, with the first region becoming the main server and others as backups.

If you enable Pgpool-II, it adds a node for load balancing and managing your databases across regions. Choose where these Pgpool-II nodes will be deployed to complete your setup. Click on ‘install’.

The setup process may take a few minutes. Once it’s done, you’ll get a confirmation message and emails with essential details like how to access your setup and login credentials.

To find everything easily, switch to the designated group (like pgcluster) as mentioned earlier.

In your multi-region cluster, the main entry point is handled by the leader Pgpool-II node deployed in the first region.

If this node encounters an issue, you can still access your cluster through any other Pgpool-II node using its hostname or IP address.

The emails will notify you once the Pgpool-II node and PostgreSQL multi-region cluster installation is successfully completed.

They will include details about the entry point, such as the hostname for accessing the admin panel, along with the database credentials needed to manage your cluster.

Choose the host URL and log in using your database credentials.

Once logged in, the PostgreSQL database is ready for use.

In summary, set up the PostgreSQL Multi-Region Cluster by choosing your version, naming your environment, selecting deployment regions, enabling Pgpool-II for load balancing, and completing installation.

After setup, check your emails for access details. Once logged in, your PostgreSQL database is ready for seamless multi-region use.