[Postgres-xc-general] HA features interrogations

[Thibault M. <thi...@ec...>]

Hi,
I am setting up a High Availability (HA) architecture and I use PG-XC. 
Thank you very much for your work, it works fine and you are the only 
one active project for synchronous multi master replication.

I don't understand why GTM proxies and GTM standby don't 
reconnect/promote themselves in case of GTM crash.
At the moment, I use shell script to do this but I am not enthusiast 
with this because of maintenance trouble in future.
Is there any reason of this lack of automation ?

Still about HA feature, I realized that when all cluster start, if GTM 
doesn't work neither does GTM standby. Obviously database doesn't work 
in that case.
I also made a script to handle this situation and change GTM standby 
config in order to transform it in GTM before starting. (Not using 
promote command, only changing configuration file). Maybe I missed 
something to make it work ? If not, could it be a new feature for future 
release ?

You can find my script on my puppet module for postgres-xc : 
https://forge.puppetlabs.com/echoes/postgres_xc or 
https://github.com/echoes-tech/puppet-postgres_xc.

Best regards,
Thibault Marquand