Re: pg_dump vs pg_basebackup - Mailing list pgsql-performance

From Ilya Kosmodemiansky
Subject Re: pg_dump vs pg_basebackup
Date
Msg-id CAG95seWXZo9O_AJs_cNyiyw8obN7guaeRutzDCN1oaiGTReP6w@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump vs pg_basebackup  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: pg_dump vs pg_basebackup  ("Graeme B. Bell" <grb@skogoglandskap.no>)
List pgsql-performance
Joshua,

On Tue, Mar 25, 2014 at 4:22 PM, Joshua D. Drake <jd@commandprompt.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@postgresql-consulting.com


pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: pg_dump vs pg_basebackup
Next
From: Ilya Kosmodemiansky
Date:
Subject: Re: pg_dump vs pg_basebackup