DBA Hub

📋Steps in this guide1/1

Check streaming recovery status

-- Run this on hot standby server

postgresql configurationintermediate
by PostgreSQL
14 views
1

Check streaming recovery status

Code/Command (click line numbers to comment):

1
2
3
4
5
6
-- Run this on hot standby server
postgres=# select pg_is_wal_replay_paused();
pg_is_wal_replay_paused
-------------------------
f
-- If the output is f then, streaming recovery is running, if t means not running.

Comments (0)

Please to add comments

No comments yet. Be the first to comment!