If you are looking into PostgreSQL replication, load balancing, and pooling, there are many solutions in the PostgreSQL world than can help you achieve your goal. There is no single solution to fit all requirements. End users can choose from a variety of PostgreSQL replication, failover and pooling solutions.
PostgreSQL clustering und failover
Do you need high availability? Is downtime simply not acceptable? We can certainly help. CYBERTEC has years of experience and has built countless HA-solutions for customers around the globe.
If you are looking for automated failover and clustering, click here >>.
High availability with Patroni
Patroni is an Open Source Cluster-Technology, which takes care of automatic failover and high availability of your PostgreSQL database. Tthe Patroni-Clusters are very easy to set up and to use. Ensure high availability of your database with Patroni >>!
PostgreSQL “Point-In-Time-Recovery” (PITR)
At times hardware can fail and filesystems can crash. Sometimes even users make mistakes and data can be lost. Point-In-Time-Recovery (PITR) is a way to recover data quickly and easily in an emergency.
Point-In-Time-Recovery helps prevent data loss.
PostgreSQL transaction log archiving can be configured in a way to ensure that no data is lost due to crashes or human error. PostgreSQL transaction log archiving is the ideal solution for protecting your data >>.
PostgreSQL synchronous and asynchronous replication
PostgreSQL offers synchronous, as well as asynchronous replication. The user can decide which way to replicate. Various methods are available and with the introduction of PostgreSQL 10.0 there are even so-called quorum-COMMITs.
If you are uncertain about which replication method to use, we are happy to help >>.
Scaling with PL/Proxy
PL/Proxy is the traditional way to scale out PostgreSQL. The idea behind PL/Proxy is to provide a stored procedure language that was only there to scale out close to infinity. For many years PL/Proxy was the key to scaling OLTP beyond a single machine.
If you are a user of PL/Proxy or if you would like to find out more, click here >>.
Contact us today to receive your personal offer from CYBERTEC. We offer timely delivery, professional handling, and 20 years of PostgreSQL experience.Contact us >>