Re: pg data backup from vps

2017-12-02 Thread Sameer Kumar
On Sat, Dec 2, 2017 at 8:02 AM John R Pierce wrote: > On 12/1/2017 12:44 PM, basti wrote: > > 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. > You have not m

Re: pg data backup from vps

2017-12-01 Thread John R Pierce
On 12/1/2017 12:44 PM, basti wrote: 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. a wal archive plus occasional basebackups lets you restore to any point in time (PITR) covered

Re: pg data backup from vps

2017-12-01 Thread Rory Campbell-Lange
On 01/12/17, support-tiger (supp...@tigernassau.com) 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 m

Re: pg data backup from vps

2017-12-01 Thread basti
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

Re: pg data backup from vps

2017-12-01 Thread Joshua D. Drake
On 12/01/2017 11:56 AM, 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 s

Re: pg data backup from vps

2017-12-01 Thread Melvin Davidson
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 transferrin

Re: pg data backup from vps

2017-12-01 Thread Rob Sargent
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

pg data backup from vps

2017-12-01 Thread support-tiger
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 postg