High Availability, guarantee to use sync nodes - Mailing list pgsql-general

From Dirk Krautschick
Subject High Availability, guarantee to use sync nodes
Date
Msg-id AM0PR05MB60829E7C9F904DE537220587E9510@AM0PR05MB6082.eurprd05.prod.outlook.com
Whole thread Raw
Responses Re: High Availability, guarantee to use sync nodes  (Maksim Milyutin <milyutinma@gmail.com>)
List pgsql-general

Hi all,

 

if there are several PostgreSQL nodes replicating synchronous and I configure a guarantee that

for example 3 of 5 nodes have to be in sync to go on with synchronous_standby_names and

now I want to implement a load balancing scenario with active standby DBs…how or with what

tool can I achieve that my read clients only use sync nodes. For sure somehow a check in the

pg_stat_replication before is possible but is there something in parameters or with solutions

like repmgr, patroni, etc. to do this?

 

Thanks and best regards

 

Dirk

pgsql-general by date:

Previous
From: "Sengottuvelusamy, Karthikeyan"
Date:
Subject: Re: Query performance with min and filter
Next
From: Thomas Kellerer
Date:
Subject: Re: How bad is using queries with thousands of values for operators IN or ANY?