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 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
signature.asc
Description: PGP signature
