Sample Header Ad - 728x90

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