Re: pg data backup from vps

On Fri, Dec 1, 2017 at 3:07 PM, Rob Sargent <robjsargent(at)gmail(dot)com> 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.