PostgreSQL

Version 10, 11, 12, 13, 14

Manage and take control of your growing PostgreSQL environments without sacrificing high availability at all levels through ClusterControl’s unified management console.

Tech highlights

Distributions

  • PostgreSQL
  • EnterpriseDB
  • Operating system provided repository
  • Custom repository binaries

Replication types

  • Standalone
  • Streaming replication

Top features

  • PgBouncer deployable
  • Advanced backup & restore
  • Optimized replication

PostgreSQL + ClusterControl Load balancers & high availability deployments

In addition to deploying a PostgreSQL cluster, you can add PgBouncer to the nodes, rebuild the replica from a single node or even recreate the cluster from a cloud backup.

Try ClusterControl with PostgreSQL for yourself!

Features list

Cluster management
— Deploymentcheck
— Add / clone / duplicate / remove / decommission nodecheck
High availability
— Load balancerscheck
— Asynchronous / synchronous replicationcheck
Backup & Restore
— Full / incremental / partialcheck
— Local / cloud storagecheck
— Encryptioncheck
— Compressioncheck
— Restore: PITRcheck
Security summary
— Key Managementcheck
— LDAP integrationcheck
— Audit logcheck

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