Skip site navigation (1) Skip section navigation (2)

Re: libpq connectoin redirect

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: libpq connectoin redirect
Date: 2010-04-21 21:06:47
Message-ID: 4BCF68E7.2000004@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-hackers
feng tian wrote:
> Hi,
>
> I want to load balance a postgres server on 4 physical machines, say 
> 127.0.0.11-14.  I can set up a pgbouncer on 127.0.0.10 and connection 
> pooling to my four boxes.  However, the traffic from/to clients will 
> go through an extra hop.  Another way to do this, is to send the 
> client an "redirect" message.  When client connect to 127.0.0.10, 
> instead of accepting the connection, it can reply to client telling it 
> to reconnect to one of the server on 127.0.0.11-14. 
>
> I am planning to write/submit a patch to do that.  I wonder if there 
> is similar effort in extending libpq protocol, or, if you have better 
> ideas on how to achieve this.

how do you plan on maintaining consistency, transactional integrity and 
atomicity of updates across these 4 machines?



In response to

pgsql-hackers by date

Next:From: James William PyeDate: 2010-04-21 22:52:39
Subject: Re: libpq connectoin redirect
Previous:From: Tom LaneDate: 2010-04-21 21:02:38
Subject: Re: plpgsql GUC variable: custom or built-in?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group