Postgres Pro
Downloads
Home   >   mailing lists

Slow backups over VPN - Mailing list pgsql-admin

From Rob Richardson
Subject Slow backups over VPN
Date
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBDD844867A@RADCONWIN2K8PDC.radcon.local
Whole thread Raw
Responses Re: Slow backups over VPN  (Steve Crawford <scrawford@pinpointresearch.com>)
Re: Slow backups over VPN  (Ray Stell <stellr@vt.edu>)
Re: Slow backups over VPN  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

I have a tiny database that I need to take frequent backups of.  The database is on a test server in our office.  When I’m at the office, backups take only a few seconds.  But when I am working from home, connecting to the office through a SonicWall VPN, backups take a few minutes.  Other data transfer operations, like file copies, are reasonably fast.  I’ve seen this behavior for databases using PostgreSQL8.4, 9.0 and 9.3.  Can you suggest any way that I might get backups to be reasonably fast?

 

Thanks very much!

 

RobR

pgsql-admin by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: How to avoid generation huge pg_xlog files during VACUUM , REINDEX maintenance task.
Next
From: Steve Crawford
Date:
Subject: Re: Slow backups over VPN