The PostgreSQL administration field guideField notes · Runbooks · Free certification

Production Operator · Module

Replication, lag, and failover readiness

Locate replication delay, judge data-loss risk, and decide whether a standby is ready for a controlled failover.

Start the first section
Total time
About 52 minutes
Learning sections
3
Practice
Real SQL in a disposable PostgreSQL lab
Reward
Shareable module certificate after you pass

01 · Learn

What you will learn

Locate replication delay, judge data-loss risk, and decide whether a standby is ready for a controlled failover.

  • Follow WAL from primary to standby
  • Find what is slowing replay
  • Decide whether failover is safer than waiting

02 · Use it

Why this matters

Promoting an unhealthy or stale standby can extend an outage and lose more data than the agreed recovery target.

03 · Practise

What you will do

Read each short section, answer a quick understanding check, then use real SQL to solve a guided task in your own temporary database.

04 · Prove it

How you will finish

Pass the SQL lab and the module assessment. Your result is saved to your signed-in account, and a module certificate is created if you pass.

Before you start

What you should know