On Fri, Mar 16, 2012 at 2:20 PM, Aleksey Tsalolikhin <atsaloli.tech@xxxxxxxxx> wrote: > On Thu, Mar 15, 2012 at 6:43 AM, Aleksey Tsalolikhin > <atsaloli.tech@xxxxxxxxx> wrote: > Our database is about 200 GB - over a WAN link, last time it took 8 > hours to do a full sync, I expect it'll be > more like 9 or 10 hours this time. > Aleksey, a suggestion: The vast majority of the postgresql wire protocol compresses well. If your WAN link is not already compressed, construct a compressed SSH tunnel for the postgresql TCP port in the WAN link. I've done this when rebuilding a 300GB database (via slony) over a bandwidth-limited (2MB/s) VPN link and it cut the replication resync time down significantly. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
