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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
