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
Try ClusterControl with PostgreSQL for yourself!
Features list
Cluster management | |
— Deployment | |
— Add / clone / duplicate / remove / decommission node | |
High availability | |
— Load balancers | |
— Asynchronous / synchronous replication | |
Backup & Restore | |
— Full / incremental / partial | |
— Local / cloud storage | |
— Encryption | |
— Compression | |
— Restore: PITR | |
Security summary | |
— Key Management | |
— LDAP integration | |
— Audit log |
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.