Skip to main content
1-Visitor
November 23, 2017
Question

Thingworx DB (Postgres) HA architecture

  • November 23, 2017
  • 1 reply
  • 1688 views

Hi,

We have configured DB HA architecture for our project.  postgres 9.4.9 on RHEL 7.1

A(master) B(slave primary) and C (salve secondary)

A--->B, A--->C synchronous replication. Replication works as expected

When  A(Master) is stopped --> failover.sh script is triggered by pgpool--> B becomes new master -->C is rebuilt successfully from B(retergetmaster.sh),

but after that pgpool is unable to connect to new master (B), it still keeps on looking for old master (A),

If we manually kill failover.sh process on pgpool machine, pgpool connects to new master (B)

has any body faced this issue , how to resolve it ?

attached the the files

Br,

Aniruddha

1 reply

5-Regular Member
January 3, 2018

Hi Aniruddha Vaidya​, I believe you have logged a support case for this query. Our Services team is assisting you on this query.


Regards,

Mohit Goel