Re: pg data backup from vps

On Fri, Dec 1, 2017 at 3:07 PM, Rob Sargent wrote: > > > On 12/01/2017 12:56 PM, support-tiger wrote: > >> To diversify risk, we would like to have a daily or weekly data backup >> stored in another location besides the VPS service we are using - pg_dump >> is great for the backup but transferring a growing db across the internet >> to a local machine disk seems slow - how are others handling this with >> postgresql ? Thks. >> >> So long as you're looking for more kinds of risk, why not stream the WAL > files to another instance? > > > >how are others handling this with postgresql ? One technique is to replicate to a slave on another server and do the pg_dump on the slave. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.