libpq connectoin redirect - Mailing list pgsql-hackers

From feng tian
Subject libpq connectoin redirect
Date
Msg-id BAY144-W986879BF29F093C17E6F280090@phx.gbl
Whole thread Raw
Responses Re: libpq connectoin redirect  (John R Pierce <pierce@hogranch.com>)
Re: libpq connectoin redirect  (James William Pye <lists@jwp.name>)
Re: libpq connectoin redirect  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Hi,<br /><br />I want to load balance a postgres server on 4 physical machines, say 127.0.0.11-14.  I can set up a
pgbounceron 127.0.0.10 and connection pooling to my four boxes.  However, the traffic from/to clients will go through
anextra hop.  Another way to do this, is to send the client an "redirect" message.  When client connect to 127.0.0.10,
insteadof accepting the connection, it can reply to client telling it to reconnect to one of the server on
127.0.0.11-14. <br /><br />I am planning to write/submit a patch to do that.  I wonder if there is similar effort in
extendinglibpq protocol, or, if you have better ideas on how to achieve this.<br /><br />Thank you,<br />Feng<br /><br
/><br/><hr />The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. <a
href="http://www.windowslive.com/campaign/thenewbusy?tile=multicalendar&ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5"
target="_new">Getbusy.</a> 

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Should database = all in pg_hba.conf match a replication connection?
Next
From: Tom Lane
Date:
Subject: Re: plpgsql GUC variable: custom or built-in?