| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | support-tiger <support(at)tigernassau(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg data backup from vps |
| Date: | 2017-12-01 20:36:06 |
| Message-ID: | 35bcb006-a228-45e6-395b-b7468f3e559c@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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. *****
| From | Date | Subject | |
|---|---|---|---|
| Next Message | legrand legrand | 2017-12-01 20:38:59 | Re: PostgreSQL and Data Warehouse optimizations |
| Previous Message | Melvin Davidson | 2017-12-01 20:10:09 | Re: pg data backup from vps |