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

Re: libpq connectoin redirect

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: feng tian <ft_uw(at)hotmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: libpq connectoin redirect
Date: 2010-04-22 05:30:40
Message-ID: 4BCFDF00.6080101@enterprisedb.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.  

One common way to do that is to set up one DNS entry for those 4 IP
addresses.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2010-04-22 05:57:43
Subject: Re: testing HS/SR - 1 vs 2 performance
Previous:From: Jeff DavisDate: 2010-04-22 02:36:00
Subject: Re: extended operator classes vs. type interfaces

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