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
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
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
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 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
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