PostgreSQL

Version 12, 13, 14, 15

Want managed PosgreSQL with the freedom to deploy it on-prem, in the cloud, or both? ClusterControl simplifies Day 2 ops for you, anywhere.

PostgreSQL

Tech highlights

Distributions

  • PostgreSQL
  • EnterpriseDB
  • TimescaleDB

Replication types

  • Streaming replication
  • Synchronous – Suitable for failover and read-only load balancing operations
  • Asynchronous – Suitable for replication to remote locations for disaster recovery

Top features

  • Highly available load balancer deployment with HAProxy and Keepalived
  • Connection pooling with PgBouncer
  • Primary cluster to replica cluster replication (cluster-to-cluster replication)
  • Automated major & minor upgrades
  • Local and cloud backups
  • pgvector extension for AI workloads

Easily deploy highly available PostgreSQL

Simply deploy a PostgreSQL cluster, add PgBouncer, rebuild a replica from a single node or even recreate your cluster from a cloud backup.

Features list

Licenses
Open Sourcecheck
Enterprisecheck
Cluster management
Deploy / importcheck
Add / duplicate / remove / decommission nodecheck
High availability
Load balancerscheck
Automated failovercheck
Asynchronous / synchronous replicationcheck
Backup / restore
Full / differential / incremental backupscheck
Backup compression / encryptioncheck
Local / cloud backupscheck
Observability
Infrastructure / database / query monitoringcheck
Dashboarding / alertingcheck
Security / compliance
Role-based access controlcheck
Key managementcheck
LDAP integrationcheck
TLS encryptioncheck
Reportingcheck
Audit logcheck

Want some CC for Postgres information for later?

Top rated Docs

Create a Database Cluster docs

Nodes docs

Backups docs

Top rated Blogs

Upgrading PostgreSQL 11 to PostgreSQL 13 with TimescaleDB and PostGIS in Linux using pg_upgrade

How to Configure PostgreSQL Sharding with ClusterControl

PostgreSQL Replication Best Practices – Part 1

I have a specific need to create replication replicas quite often and am tired of having to tweak homegrown scripts. How have you solved this?

For creating new replicas, rebuilding, or resyncing, it’s just a click of a button, explained here.

My PostgreSQL install has just been created and had data imported from other sources. Will I have to repeat this for ClusterControl to work?

No. Just import the PostgreSQL instance into ClusterControl, and then you can add replicas as you see fit.

I’m new to PostgreSQL and HAProxy and worried about how to configure both properly. How can I do this safely?

Check out the configurations page that gives you the ability to adjust the pg_hba.conf and postgresql.conf files from the GUI.

6 easy steps to get started with ClusterControl