| From: | Ilya Kosmodemiansky <ilya(dot)kosmodemiansky(at)postgresql-consulting(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | Claudio Freire <klaussfreire(at)gmail(dot)com>, David Johnston <polobo(at)yahoo(dot)com>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: pg_dump vs pg_basebackup |
| Date: | 2014-03-25 15:29:11 |
| Message-ID: | CAG95seWXZo9O_AJs_cNyiyw8obN7guaeRutzDCN1oaiGTReP6w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Joshua,
On Tue, Mar 25, 2014 at 4:22 PM, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
The advantage is that you can create backups that don't
> have to be restored, just started. You can also use the differential
> portions of rsync to do it multiple times a day without much issue.
Are you sure, that it is a nice idea on a database with heavy write workload?
And also Im not sure, that differential backups using rsync will be
recoverable, if you have actually meant that.
>
>
> JD
>
> --
> Command Prompt, Inc. - http://www.commandprompt.com/ 509-416-6579
> PostgreSQL Support, Training, Professional Services and Development
> High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
> Political Correctness is for cowards.
--
Ilya Kosmodemiansky,
PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik(at)postgresql-consulting(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ilya Kosmodemiansky | 2014-03-25 15:37:41 | Re: pg_dump vs pg_basebackup |
| Previous Message | Joshua D. Drake | 2014-03-25 15:22:55 | Re: pg_dump vs pg_basebackup |