the FDW in the P server to avoid the "
> external server " ?
>
> => What about the trigger-based replication systems like Slony or
> Londiste ; is it really necessary to have a connection or flow from
> the server S towards the server P ?
>
> Regards
> De: "
which you replay to your remote S, with no connectivity to P.
Regards
*De: *"PALAYRET Jacques"
*À: *pgsql-general@lists.postgresql.org
*Envoyé: *Lundi 3 Juin 2019 18:00:51
*Objet: *One way replication in PostgreSQL
Hello,
If, for
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 "
What about the trigger-based replication systems like Slony or Londiste ; is
it really necessary to have a connection or flow from the server S towards the
server P ?
Regards
De: "PALAYRET Jacques"
À: pgsql-general@lists.postgresql.org
Envoyé: Lundi 3 Juin 2019 18:00:51
Objet
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
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
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
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
