DR replication Stoped after failover

[seyiisq]

Dear Team,

Recently, our staging database environment was not available so we had to promote the DR database using the script below.

[root@DRPOSDB tmp]# su postgres
bash-4.2$
bash-4.2$
bash-4.2$
bash-4.2$
bash-4.2$ /usr/pgsql-9.2/bin/pg_ctl -D /target_directory promote
pg_ctl: PID file "/target_directory/postmaster.pid" does not exist
Is server running?
bash-4.2$
bash-4.2$
bash-4.2$ locate postmaster.pid
/var/lib/pgsql/9.2/data/postmaster.pid
bash-4.2$
bash-4.2$
bash-4.2$ /usr/pgsql-9.2/bin/pg_ctl -D /var/lib/pgsql/9.2/data promote
server promoting
bash-4.2$
bash-4.2$
bash-4.2$
bash-4.2$

No changes was made to the database while in DR because the live came up alomost immediately.

Now replication as stopped because DR was promoted from slave to master. Also, data has started coming to LIVE database.

How do we make replication to start again, i have not been able to see any documentation to do this.

[zmbd]

Never worked with PostGreSql; however, looking through some documentation about this database I found this:
https://wiki.postgresql.org/wiki/Streaming_Replication
It mentions that this feature was added to PostgreSQL 9.0 - so I think this might be available; however, you don't mention which version you're using.

Towards the bottom of this page it mentions repeating from Step 6 - Might be a starting point.

[seyiisq]

Thanks zmbd,

This is like revisiting the setup again. I will GI through it and get back.

I am currently on postgres9.2

[zmbd]

Best of Luck - hopefully one of the other experts has more experience with this DB