Re: PostgreSQL: How can use slave for some read operations?

Thank you for the clarification. On Wed, Mar 15, 2023 at 1:42 PM Илья Шипицин wrote: > there are several L7 balancing tool like pgPool. > > as for haproxy, currently it does not provide such advanced postgresql > routing > > ср, 15 мар. 2023 г. в 06:09, Muhammed Fahid : > >> Hi, >> >> I have A

Re: Debugging PH state

On 2023-03-13 15:50, Christopher Faulet wrote: Le 3/6/23 à 08:50, Christian Ruppert a écrit : On 2023-03-03 16:37, Christopher Faulet wrote: Le 3/3/23 à 15:40, Christian Ruppert a écrit : So I can reproduce it. I captured the response, extracted the data which includes to entire header +

Re: PostgreSQL: How can use slave for some read operations?

what i have done is create frontends and backends for all of the load balanced nodes, and separate f/e and b/e for the individual nodes.  for instance: frontend mariadb     mode tcp     bind 192.168.120.3:3306     default_backend mariadb frontend mariadb1     mode tcp    

Re: PostgreSQL: How can use slave for some read operations?

there are several L7 balancing tool like pgPool. as for haproxy, currently it does not provide such advanced postgresql routing ср, 15 мар. 2023 г. в 06:09, Muhammed Fahid : > Hi, > > I have A master and a slave PostgreSQL databases. I would like to know > that major read operations can be