PostgreSQL Cluster Hosting

PostgreSQL Primary-Secondary Cluster enhances data availability through asynchronous replication. As a powerful, open-source object-relational database system, it offers a highly available and reliable setup with automatic multi-region distribution for optimal performance.

Network Isolation

Network Isolation

Keeps accounts and environments separate unless explicitly permitted, ensuring secure connections within isolated groups.
 

Failover Protection

Failover Protection

Ensures automatic failover for PostgreSQL, switching to a backup and restoring the primary when online.

Asynchronous Replication

Asynchronous Replication

Uses Write-ahead logging for fast asynchronous replication, sending archived data from the primary to the backup server.

Your instances will automatically scale up and down with traffic fluctuations, while also allowing you the flexibility to set budget limits.

Loading...

Check more features

Round circle
arrow
Modern Girl

AccuWeb.Cloud is 40% more affordable

than other
Hyperscalers

Price comparison with other Hyperscalers

Comparison for "1VCPU / 2 GB Memory / 50 GB SSD" Container

AccuWeb.Cloud
$18.07
Oracle
$27.42
DigitalOcean
$28
Google Cloud
$30
Microsoft Azure
$48.18
IBM
$50
AWS
$51.3

How to Manage PostgreSQL Cluster

  • Getting Started
  • Cluster Customization
  • Access the Cluster
  • Cluster Admin Panel
  • Multi-region Cluster Setup
  • Enable Pgpool-II & Select Regions
Go to the Marketplace -> Clusters and select PostgreSQL Primary-Secodary Cluster package.
Getting Started
You can customize your PostgreSQL cluster by selecting the appropriate version, enabling the Pgpool-II load balancer, and selecting the region where you want to set up.
Cluster Customization
You can manage the PostgreSQL cluster (e.g., restart the node server, install add-ons, and edit configuration files) directly from the AccuWeb Cloud dashboard.
Access the Cluster
You can manage and control PostgreSQL databases from the Admin Panel.
Cluster Admin Panel
Check the box "Create separate environment group" and Select the regions where the cluster environment will be set up. The order is important: the first region will have the main server, and the others will have backup servers.
Multi-region cluster setup
You can enable Pgpool to add load-balancing, monitoring, and management nodes in front of database nodes in each region. Select the Pgpool region where you want to install load balance nodes.
Enable Pgpool-II & Select regions

PostgreSQL Multi-Region Cluster

AccuWeb.Cloud's PostgreSQL Multi-Region Cluster setup uses a Primary-Secondary configuration with an additional backup server for disaster recovery, resulting in a Primary-Secondary-Secondary setup. It includes a Pgpool-II Load Balancer to distribute requests and manage data replication, ensuring high availability even if one data center goes down.

You can also select the different regions for the Pgpool-II Load Balancer node server, which will reduce the data's latency.

PostgreSQL Multi-Region Cluster
View PostgreSQL Cluster Hosting Plans
Network Isolation

Network Isolation

AccuWeb.Cloud provides a Network Isolation feature for PostgreSQL databases. When enabled, all accounts are kept separate by default, and connections between environments on different accounts can only happen if both sides are specifically set up to allow it. You can also keep groups of environments separate within the same account.

With this feature, any connection between nodes on the platform must pass a check to make sure that both the requesting and receiving environments are part of the same isolated group.

Sign up and avail $100 free credits now!!

Automatic Failover Protection

AccuWeb.Cloud set Automatic Failover Protection for the PostgreSQL Cluster through a Pgpool-II load balancer. The load balancer automatically detects if the main database goes down and adds one of the backup databases to take over. When the down server is back online, it will automatically rejoin the cluster as a backup, with any missing data restored using the pgrewind tool.

High Availability

Replication is an important feature for any database server because losing data or having downtime can lead to less access, lower productivity, and a loss of trust in the product. By copying data from a main server to one or more backup servers, the risk of losing data is reduced. With PostgreSQL, it's easy to set up a group of servers where one is the main server, and the others are backups, sharing the same data.

Asynchronous Replication

AccuWeb.Cloud use WAL (Write-ahead logging) is the fastest method for data replication and offers great performance. This is called asynchronous replication. In this setup, the main database server works in archiving mode, writing WAL files to storage and then sending them to the backup server, which operates in recovery mode. The files are sent to the backup server right after they are written.

SSL/TLS Encrypted Connection

AccuWeb.Cloud allows users to enable SSL/TLS encrypted connections for the PostgreSQL Cluster. You can enable SSL/TLS from the add-on options, and the certification will be stored/installed in /var/lib/jelastic/keys/SSL-TLS.

Register Now

True Consumption-Based Pricing

When using AccuWeb.Cloud, your payment is determined by your actual usage rather than the size of your server.

The system makes hourly measurements of how many RAM and CPU resources are being used on each container and requests payment only for these used resources. You can set up a maximum Scaling Limit for each container, so the resources will always be available in case of load spikes or other consumption changes. No matter how high the limit – the payment will only be based on actual usage.

Pay for the Limits
Pay for the Usege

Get Started For Free

Register Now to Get $100 credit for your first 30 days with AccuWeb.Cloud

24*7 Expert Support

Reliable Support When you Need it the Most!

To solve your technical problems, our highly trained experts are available 24/7 via live chat and support tickets.

Reliable Support When you Need it the Most!

FAQs

What is an AccuWeb.cloud PostgreSQL Cluster?

An AccuWeb.cloud PostgreSQL Cluster is a group of databases managed by a single PostgreSQL server. It helps handle more data, ensures continuous online availability, and supports data replication.

What are the main components of a PostgreSQL Cluster?

The cluster has two main components: the data directory, which contains files created and managed by PostgreSQL (including databases and tables), and Postgres, the core program that manages these files and provides interaction methods.

How can I manage the PostgreSQL Cluster?

You can manage your PostgreSQL cluster easily through the AccuWeb.Cloud dashboard and the Cluster Admin Panel, where you can set up, customize, and control the cluster.

Can I customize my PostgreSQL Cluster?

Yes, you can customize your PostgreSQL cluster by selecting the desired version, enabling the Pgpool-II load balancer, and choosing the region where you want to set up the cluster.

How do I get started with setting up a PostgreSQL Cluster?

To set up a PostgreSQL Cluster, go to the Marketplace, select Clusters, and choose the PostgreSQL Primary-Secondary Cluster package.

Stay informed and never miss an update:

Subscribe to our newsletter for the latest news, tips, and exclusive offers!