Re: pg data backup from vps

Replication is no backup.
Its more like a RAID.

That mean tubles that are delete on master by a mistake there are also
delete on slave.

correct me if i'am wrong.

Best regards,
basti

On 01.12.2017 21:10, Melvin Davidson wrote:
> 
> 
> On Fri, Dec 1, 2017 at 3:07 PM, Rob Sargent <robjsargent@gmail.com
> <mailto:robjsargent@gmail.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.