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

Managing log shipping replication

Whether you use file-based or streaming replication as the transport mechanism, managing a log shipping replication cluster is in many ways very similar.

Getting ready

Discussion here assumes you have already set up file-based log shipping, streaming replication, or both.

How to do it...

Monitoring

Monitoring of log shipping is essential. You'll find it best to enable Hot Standby mode, as the information is both easier to obtain and more accurate if you do.

Repmgr and pgpool both provide replication monitoring facilities. Munin plugins are available for graphing replication and apply delay.

You may wish to calculate the delays yourself. To do that, we request current values from Master and Standby, and then compare the ...

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