Re: [GENERAL] Question about switchover with PG9 replication

Hello, Thanks for all your answers. I have read that the cascaded replication will be probably available in future releases (cf. http://wiki.postgresql.org/wiki/Streaming_Replication#Synchronization_capabilityat the bottom of the page) As I understand the streaming replication, we are able to h

[GENERAL] Question about switchover with PG9 replication

Hello, I have a few questions about streaming replication. We have a database of nearly 300 GB. We are using Postgres 8.3.1 and Slony for replication on Ubuntu 10.04. We have 4 Postgres servers PGMaster1, PGSlave1, PGMaster2 and PGSlave2 on 2 distant sites (distance between the 2 sites is nearly