PostgreSQL High Availability

PostgreSQL High Availability

By  malcolmcerfonteyn

Service Provider: EmblocSoft (Hong Kong) Ltd.    

w: | e: | t: +852-2581-2188 | f: +852-2581-0128


PostgreSQL High Availability (or simply PostgreSQL HA)  is a feature of PostgreSQL that replicates data from one PostgreSQL database server (called the master) to one or more PostgreSQL database servers (slaves).  Database servers therefore can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing), database servers could work together seamlessly.

The PostgreSQL HA Setup Service includes:

  • Designing replication setup
  • Analysis of uptime requirements and data latency
  • Configuring replication master
  • Configuring a replication slave without synchronizing data
  • Configuring a replication slave and migrating data with a simple SQL dump
  • Copy and safeguard data
  • Create failover/standby capabilities
  • Manage Backup and recovery
  • Migrate systems
  • Failover tests
  • Knowledge transfer of the clustering solution

PostgreSQL HA manager talks PostgreSQL's backend and frontend protocol, and relays a connection between them. Therefore, a database application (frontend) thinks that PostgreSQL HA is the actual PostgreSQL server, and the server (backend) sees PostgreSQL HA as one of its clients. Because PostgreSQL HA is transparent to both the server and the client, an existing database application can be used with PostgreSQL almost without a change to its sources.


Please feel free to use the Contact-Us form to contact us now if you have any queries.

PostgreSQL, Open Source, database, Oracle, SQLServer, MYSQL