I have postgresql replication system with two machines, suppose I want to change the master ip,the streaming to slave machine will stop. Can I resume streaming with the new master ip instead of doing the replication from scratch.
Postgresql – Master ip has changed in postgresql replication
postgresqlreplication
Related Question
- Postgresql – Streaming replication – STONITH
- PostgreSQL – Handling Corruption in Streaming Replication Master
- Postgresql Streaming Replication Error: WAL segment removed
- PostgreSQL Failover – One Master Multiple Slaves Setup
- Postgresql – Setup VIP for PostgreSQL Replication
- Mysql – Change host IP of master in thesql replication
- Postgresql crash in master node with streaming replication
Best Answer
Easy, just change
host
inprimary_conninfo
and restart the standby.This replication parameter can be found in
recovery.conf
before v12 and inpostgresql.conf
after that.