Greetings, * PALAYRET Jacques (jacques.palayret@xxxxxxxx) 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 one of the various backup tools that do that- eg: you could use pgbackrest in the archive_command of the primary system and push WAL to a repo that's on the replica (or some other system that the replica is allowed to connect to). > If possible, I would prefer partial replication (only some tables) to full base replication (all instances). Just to be clear, you couldn't use a WAL-based shipping method for partial replication (at least, not today anyway). Thanks, Stephen
Attachment:
signature.asc
Description: PGP signature
