TechNewsHeaven {{}}

Three Approaches to PostgreSQL Replication and Backup
2018-02-24T01:37:42.9546407Z - / Hacker News
For replication, our database as a service (by default) leverages the streaming replication logic built into Postgres. In the context of Postgres, the built-in replication (known as “streaming replication”) comes with several challenges:Postgres replication doesn’t come with built-in monitoring and failover. When you need to construct a new secondary node, the secondary needs to replay the entire history of state change from the primary node. PostgreSQL streaming replication to replicate data from primary to secondary node. Approach 1: Streaming replication in PostgreSQL (with local storage)This first approach is the most common one.

Your favorite news

Popular news

Recommended news