[Slony1-general] Replication cascade with 2 differents replications on the same table

[Richard Yen]

On Wed, May 26, 2021 at 5:51 AM Sebastien Marchand <smarchand at sgo.fr> wrote:

> Hi,
>
> thank you, but i don't know how do this, my server A can't talk to my
> server C...
>
Hi Sebastien,

Do you mean that you have not been able to get Server A to talk to Server C
via Slony (but you can ping A from C), or do you mean that they are
physically separated and there is no network path for A to talk to C,
except via Server B?

If the latter is the case for you, then I think you will not be able to set
up this kind of cascading replication, due to the session replication role
I had mentioned in my earlier email (I actually tried to create a
rudimentary patch to make it work, but I haven't yet figured out the
details to actually pass QA [1])

If your case is the former (i.e., you can ping Server A from C), then I
think Stéphane's suggestion should work for you

[1]:
https://www.slony.info/pipermail/slony1-patches/2020-February/000123.html

--Richard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.slony.info/pipermail/slony1-general/attachments/20210526/89ef6c4e/attachment.htm>