cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Thingworx DB (Postgres) HA architecture

avaidya1
1-Newbie

Thingworx DB (Postgres) HA architecture

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 1
mgoel
17-Peridot
(To:avaidya1)

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

Top Tags