PostgreSQL capabilities
PostgreSQL provides enterprise-level services which guarantee the continuation of the business.
Replication
Replication allows data from one database server to be replicated to another server. Replication is used mainly to achieve the following:
- High availability: A second server can take over if the primary server fails.
- Load balancing: Several servers can serve the same requests.
- Faster execution: A query is executed on several machines at once to gain performance.
PostgreSQL supports replication out of the box via streaming replication. Streaming replication is a master-slave replication that uses file-based log shipping. Streaming replication is a binary replication technique, because SQL statements are not analyzed. It is ...
Get Learning PostgreSQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
