Restart master in physical replication
2
votes
1
answer
1929
views
I have 2 servers involving
master-slave
replication (physical replication).
I see the replication using select * from pg_replication_slots;
there is a record saying :
user : rep_user`
application : 12/main
state : streaming
I have to change postgresql.conf
on the master to enable pg_cron
extension so I need to restart the master.
Is it safe to just restart it using : sudo service postgresql stop
followed by sudo service postgresql start
? Do I have to drop the replication first before restarting?
thanks
Asked by padjee
(337 rep)
Dec 5, 2022, 06:02 AM
Last activity: Dec 9, 2022, 03:21 AM
Last activity: Dec 9, 2022, 03:21 AM