Re: [GENERAL] Manage slot in logical/pglogical replication

2017-07-19 Thread dpat
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

[GENERAL] Manage slot in logical/pglogical replication

2017-07-12 Thread dpat
Hi, i have configure a master-replica replication with new pglogical 2.0. I have to replicate data over MPLS/VPN, so there is a possibility that the link temporarily interrupts. I know that you have to be accurately estimated pg_xlog folder. How can I handle the prolonged interruption of the link?