Re: [GENERAL] pg 9.0, streaming replication, fail over and fail back strategies

2010-08-09 Thread Kyle R. Burton
>> 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?) > >

[GENERAL] pg 9.0, streaming replication, fail over and fail back strategies

2010-08-09 Thread Kyle R. Burton
Hello, I'm new to the list and not even sure if this is the right place to be posting this... I've worked through the documentation for postgres 9.0 (beta2) and have successfully set up a master and hot slave configured with streaming replication (and xlog shipping).  That configuration seems to