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 slow - how are others
> handling this with postgresql ? Thks.
I would consider something like an archiving slave (PITR).
JD
--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc
PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.org
***** Unless otherwise stated, opinions are my own. *****