Greetings,
* PALAYRET Jacques (jacques.palayret@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 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