Re: One way replication in PostgreSQL

Greetings,

* PALAYRET Jacques (jacques(dot)palayret(at)meteo(dot)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