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.