The FDW is a PostgreSQL extension to connect to other server from
PosgreSQL server inside, with this solution you only need connections
from P to S and no need a third server (external server), just use
triggers to push the INSERT/UPDATE/DELETE information you want to
replicate from P to S through
On 4/6/19 10:02 π.μ., PALAYRET Jacques wrote:
Hello,
Thanks a lot for the suggested solutions.
So, I can use WAL-shipping replication from Primary to the Secundary server,
but it's only for full replication.
Let's call " P " the provider/primary/master and " S " the
subscriber/secundary/sla
Le mar. 4 juin 2019 à 09:03, PALAYRET Jacques a
écrit :
> Hello,
>
> Thanks a lot for the suggested solutions.
>
> So, I can use WAL-shipping replication from Primary to the Secundary
> server, but it's only for full replication.
>
>
Yes.
Let's call " P " the provider/primary/master and " S " t
Hello,
Thanks a lot for the suggested solutions.
So, I can use WAL-shipping replication from Primary to the Secundary server,
but it's only for full replication.
Let's call " P " the provider/primary/master and " S " the
subscriber/secundary/slave one.
For partial replication (not all the
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 app
Hi,
On 6/3/19 6:00 PM, 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 ?
>
To perform replication, you need some form of connectivity be
Greetings,
* PALAYRET Jacques (jacques.palay...@meteo.fr) wrote:
> 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 ?
The simplest approach might be to use WAL shipping with
