PostgreSQL replication


PostgreSQL Replication shows the monitored server's replication role, visible standbys, replication slots, WAL/archiver signals, and replica conflict evidence.

What to review

  • Server role and topology.
  • Connected standbys from pg_stat_replication.
  • Replication slot activity and retained WAL.
  • Replay lag where available.
  • Archiver failures and WAL archiving rate.
  • Replica conflict counters.

Workflow

  1. Open the PostgreSQL server in the navigation tree.
  2. Select Replication.
  3. Review the summary pills for role, connected standbys, slots, replay lag, retained WAL, archiver failures, and conflicts.
  4. Use the topology strip to confirm which standby connections are visible to the monitored server.
  5. Review Standbys, Replication Slots, Archiver, and Replica Conflicts tabs for detail.

How to interpret replication signals

On a primary server, missing standbys, inactive replication slots, increasing retained WAL, and replay lag are the main signals to investigate. Retained WAL can fill disk even when the primary itself is otherwise healthy.

On a standby server, WAL receiver and conflict counters can explain why replay is delayed or why read queries are being cancelled. Some cloud providers restrict access to replication views, so missing rows may mean a permission or platform limitation rather than no replication.

Alerts

Mini DBA can raise PostgreSQL alerts for connected standby count, inactive replication slots, replication lag, and replication-slot retained WAL. Use the Replication page to inspect the source evidence behind those alerts.

Related pages