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
On Sun, Feb 27, 2011 at 3:46 AM, Cyril Scetbon wrote:
> Le 07/02/2011 09:57, Wouter D'Haeseleer a écrit :
>
> Question 1 : is it possible to have such a replication configuration with
> the streaming replication of PG9 (cascaded replication) ?
>
> Nope, as far as I have tested pg only has 1 master
Le 07/02/2011 09:57, Wouter D'Haeseleer a écrit :
Question 1 : is it possible to have such a replication configuration
with the streaming replication of PG9 (cascaded replication) ?
Nope, as far as I have tested pg only has 1 master and can have a
number of slaves, so having 2 masters i
On Mon, Feb 07, 2011 at 09:20:36AM +0100, Jean-Armel Luce wrote:
> Is it possible to do switchover between sites (between PGMaster1 and
> PGMaster2) whithout copying all the database from the new PG master to the
> new PG slave ?
You can't do database replication without copying the whole databas
Question 1 : is it possible to have such a replication configuration
with the streaming replication of PG9 (cascaded replication) ?
Nope, as far as I have tested pg only has 1 master and can have
a number of slaves, so having 2 masters is not possible.
Question 2 : All the proce
