| The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group Paperback (6"x9"), 274 pages ISBN 9781906966072 RRP £9.95 ($14.95) Sales of this book support the PostgreSQL project! Get a printed copy>>> |
11.2.5.2 Monitoring
An important health indicator of streaming replication is the amount
of WAL records generated in the primary, but not yet applied in the
standby. You can calculate this lag by comparing the current WAL write
location on the primary with the last WAL location received by the
standby. They can be retrieved using
pg_current_xlog_location on the primary and the
pg_last_xlog_receive_location on the standby,
respectively (see Volume 1A: Table 7-56 and
Volume 1A: Table 7-57 for details).
The last WAL receive location in the standby is also displayed in the
process status of the WAL receiver process, displayed using the
ps command (see section 13.1 Standard Unix Tools for details).
| ISBN 9781906966072 | The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide | See the print edition |