Slony1 PostgreSQL Replication - How can we replicate data of master table to slave

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How can we replicate data of master table to slave

Ajay Dalvi

2005-07-08, 7:24 am

Hi all,

One problem I am facing while using Slony 1.1.0 Replication.

If there are Some rows existing in slave server table which are
altogether different from those rows in Master table.
NOw when I subscribe slave for replication, what is happening is that
all the previously existing rows of slave table are vanishing and only
those rows which are replicated from Master table are gets saved in the
slave table.

But I am having one scenario in which there are multiple sources ( we
can say multiple masters) from which I have to replicate data to one
single destination ( we can say one slave).
Of course I will have to create different sets for each Master, and will
have to subscribe onle single slave to each set for replication.

So how I will preserve the existing contents of Slave table after
replication?

-Ajay

Sponsored Links