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 <robjsarg...@gmail.com > <mailto:robjsarg...@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.
