Re: pg_dump vs pg_basebackup - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: pg_dump vs pg_basebackup
Date
Msg-id 5331A6E6.8010503@commandprompt.com
Whole thread Raw
In response to Re: pg_dump vs pg_basebackup  (Magnus Hagander <magnus@hagander.net>)
List pgsql-performance
On 03/25/2014 08:21 AM, Magnus Hagander wrote:
> I would say that's the one thing that rsync is *not*. pg_basebackup
> takes care of a lot of things under the hood. rsync is a lot more
> complicated, in particular in failure scenarios, since you have to
> manually deal with pg_start/stop_backup().
>
> There are definitely reasons you'd prefer rsync over pg_basebackup, but
> I don't believe simplicity is one of them.
>
> //Magnus

Good God man... since when do you top post!

Well there are tools that use rsync to solve those issues :P. We even
have one that does multi-threaded rsync so you can pull many Terabytes
in very little time (relatively).

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.


pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: pg_dump vs pg_basebackup
Next
From: Alan Hodgson
Date:
Subject: Re: pg_dump vs pg_basebackup