On Mon, Jul 17, 2017 at 7:08 AM, dpat <denni(dot)pat(at)gmail(dot)com> wrote:
> yes i have estimated pg_xlog but server, some time, writes a lot of WAL file.
> there are some robust alternative to replicate partial database in
> Postgresql over WAN?
> or, what's the best way to realign pglogical replica? pg_dump/restore?.
> i have to find the best way to replicate only some table over internet to
> remote database.
That's been a job for slony in the past. Now pg_logical seems to be
getting ready / is ready to replace it.