Hi team, Thanks a lot all of your help for heads up. I could able t o successfully replicate the data and test the fail over scenario by promoting the hot stand by to master. However, I need best precise solution for fail back scenario now. I mean, Switching back to to original master and slave setup.
In that case, I would like to bring back my original master to master again and promoted master back to slave.
Master is down- Promoted slave as master- Inserted few records- Need to demote the Slave and bring back the Master
Do I need to follow the same process as I created the slave initially ?
> rom: Sanjib Mohanty <sanjib.technical@gmail.com> > Sent: donderdag 6 februari 2020 14:00 > To: pgsql-admin@lists.postgresql.org > Subject: pg_basebackup fails to connect from slave server > > Hi List, > > I am new to postgres/EnterpriseDB( 9.6). In fact, I was trying to > configure one streaming replication from master to hot-standby > server. I will appreciate if I need any help or document to > configure and test in in RHEL server. > > I am using EenterpriseDB 9.6 version. > > > > > * EDB has its own support and replication solutions. > * You working with community version of PostgreSQL or EDB? > > Thanks in advance, > > Cheers, > SM
