Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump vs pg_basebackup - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: pg_dump vs pg_basebackup
Date
Msg-id CABUevEypWxUsDRG2Ro5e0Ba7excM7OwDHL75XZh=zpqr4W3NUg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump vs pg_basebackup  (Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>)
Responses Re: pg_dump vs pg_basebackup  (Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com>)
Re: pg_dump vs pg_basebackup  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
Tree view
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


On Tue, Mar 25, 2014 at 4:18 PM, Ilya Kosmodemiansky <ilya.kosmodemiansky@postgresql-consulting.com> wrote:
Joshua,

that is really good point: an alternative is to use pg_basebackup
through ssh tunnel with compression, but rsync is much simpler.

On Tue, Mar 25, 2014 at 3:56 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
>
> On 03/25/2014 05:05 AM, Claudio Freire wrote:
>>
>>
>> On Tue, Mar 25, 2014 at 4:39 AM, David Johnston <polobo@yahoo.com> wrote:
>>>>
>>>> Hai,
>>>>
>>>> Can anyone tell me the difference and performance between pgdump and
>>>> pg_basebackup if I want to backup a large database.
>>>>
>
> Honestly,
>
> Neither is particularly good at backing up large databases. I would look
> into PITR with rsync.
>
> 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.
>
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance



--
Ilya Kosmodemiansky,

PostgreSQL-Consulting.com
tel. +14084142500
cell. +4915144336040
ik@postgresql-consulting.com


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-performance by date:

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