O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

File-based log-shipping replication

Log shipping is a replication technique used by many database management systems. The Master records database changes in its transaction log and then the log files are shipped from the Master to the Standby, where the log is replayed.

File-based log shipping has been available since PostgreSQL 8.2, which is more than four years before 9.0 was released. It's a simple, very low overhead, and trustworthy form of replication.

The technique is mostly superseded by streaming replication in 9.0, though is still useful as part of a comprehensive backup strategy. It is also worth understanding how this works, as this technique can also be used as the starting phase for a large streaming replication setup. Look at the next ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required