On Mon, Aug 9, 2010 at 4:10 PM, Kyle R. Burton <kyle.burton@xxxxxxxxx> 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... -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
