libpq connectoin redirect
От
feng tian
Тема
libpq connectoin redirect
Дата
Msg-id
BAY144-W986879BF29F093C17E6F280090@phx.gbl
Список
Дерево обсуждения
libpq connectoin redirect feng tian <ft_uw@hotmail.com>
Re: libpq connectoin redirect John R Pierce <pierce@hogranch.com>
Re: libpq connectoin redirect Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: libpq connectoin redirect James William Pye <lists@jwp.name>
Re: libpq connectoin redirect feng tian <ft_uw@hotmail.com>
Re: libpq connectoin redirect feng tian <ft_uw@hotmail.com>
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.
Thank you,
Feng
The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. Get busy.
В списке pgsql-hackers по дате отправления
От: Simon Riggs
Дата:
