On Mon, Aug 9, 2010 at 4:10 PM, Kyle R. Burton <kyle(dot)burton(at)gmail(dot)com> wrote:
> Hello,
> After I had moved the VIP from the master to the slave, I had to
> restart (not just reload) the postgres daemon to get it to start
Not surprising as you say.
> Is there any way to get PostgreSQL to bind to a new ip address and
> interface without actually shutting it down? If it could, would I
> need to break all the current (read only) client connections to get
> them to reconnect and have the ability to write? (am I confused about
> this?)
I wonder if you could have pg on a steady ip and use iptables to
forward traffic there after a failover...