Skip to Content
PostgreSQL Administration Essentials
book

PostgreSQL Administration Essentials

by Hans-Jürgen Schönig
October 2014
Intermediate to advanced content levelIntermediate to advanced
142 pages
3h 9m
English
Packt Publishing
Content preview from PostgreSQL Administration Essentials

Upgrading to synchronous replication

Many people are looking for synchronous replication. I have decided to include this section in this book to clear the fog and to remove some false beliefs about synchronous replication.

First of all, the goal of synchronous replication is to narrow the window of data loss in case a server crashes. Asynchronous replication means that data is replicated with a slight delay. Synchronous replication asks the slave if the data has ended up there safely. It does not exactly guarantee that no data can be lost under any circumstances. However, it makes data loss pretty unlikely.

The second thing you have to know about synchronous replication is that you should only use synchronous replication if you have at least three ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

PostgreSQL 9 Administration Cookbook - Second Edition

PostgreSQL 9 Administration Cookbook - Second Edition

Simon Riggs, GIANNI CIOLLI, Hannu Krosing, Gabriele Bartolini

Publisher Resources

ISBN: 9781783988983