We are 40% more affordable than other Hyperscalers! Sign up and avail $100 free credits now!!

AccuWeb.Cloud

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

Ensures separation of accounts and environments, allowing secure connections only within isolated groups when explicitly permitted

Disaster
Recovery

PostgreSQL Multi-Region Cluster setup uses a Primary-Secondary configuration with an additional backup server

Asynchronous Replication

Asynchronous Replication

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

All instances at AccuWeb.Cloud are dedicated, ensuring superior performance with no resource sharing.

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
AccuWeb Cloud Hosting
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

*The comparison data has been collected based on information available as of January 1, 2024

How to Manage PostgreSQL
Cluster Hosting Environment

  • Login to Dashboard
  • Go to MarketPlace
  • Install PostgreSQL
  • Cluster Customization
  • Access the Cluster
  • Cluster Admin Panel
  • Multi-region Cluster Setup
  • Enable Pgpool-II & Select Regions
Login to Dashboard
To access the AccuWeb.Cloud dashboard, please check your registered email and enter your login details.
Go to MarketPlace
Navigate to Marketplace.
Install PostgreSQL
In Clusters,Select PostgreSQL Primary-Secondary Cluster Package and Install.
Cluster Customization
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.
Access the Cluster
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.
Cluster Admin Panel
You can manage and control PostgreSQL databases from the Admin Panel.
Multi-region cluster setup
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.
Enable Pgpool-II & Select regions
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.

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
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.

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.

Get Started For Free

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

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

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!