You could use FDW to replicate what you need to an external server from
the provider/primary/master to the subscriber/secondary/slaveUsing
triggers on the master tables that you want to replicate, you can
execute the insert/update/delete actions on the secondary tables
through the FDW.With this approach you only need a connection from
provider to the subscriber.
Regards On Mon, 2019-06-03 at 18:00 +0200, PALAYRET Jacques wrote:
> Hello,
>
> If, for security reasons, I can't create a connection or a flow from
> subscriber/secundary/slave towards provider/primary/master, witch
> replication systems can I use ?
>
> If possible, I would prefer partial replication (only some tables) to
> full base replication (all instances).
>
> Do trigger-based replication systems (like Slony or Londiste or
> others) need a connection or flow from subscriber to the provider ?
>
> Thanks in advance
> ----- Météo-France -----
> PALAYRET JACQUES
> DCSC/MBD
> jacques(dot)palayret(at)meteo(dot)fr
> Fixe : +33 561078319