DBA Hub

📋Steps in this guide1/1

How to stop /resume recovery in standy(replication)

-- To stop/pause recovery on replication server(standby)

postgresql configurationintermediate
by PostgreSQL
16 views
1

How to stop /resume recovery in standy(replication)

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- To stop/pause recovery on replication server(standby)
postgres=#
select pg_wal_replay_pause();
pg_wal_replay_pause
---------------------
(1 row)
postgres=#
select pg_is_wal_replay_paused();
pg_is_wal_replay_paused
-------------------------
t
(1 row)
-- To Resume recovery on replication server(standby)
postgres=#
select pg_wal_replay_resume();
pg_wal_replay_resume
----------------------
(1 row)
postgres=#
select pg_is_wal_replay_paused();
pg_is_wal_replay_paused
-------------------------
f
(1 row)

Comments (0)

Please to add comments

No comments yet. Be the first to comment!