Date: Tue, 25 Mar 2014 00:39:19 -0700 (PDT)
From: David Johnston <polobo@yahoo.com>
To: pgsql-performance@postgresql.org
Message-ID: <1395733159787-5797364.post@n5.nabble.com>
In-Reply-To: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com>
References: <1395722709.28433.YahooMailNeo@web161601.mail.bf1.yahoo.com>
Subject: Re: pg_dump vs pg_basebackup
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

gianfranco caca wrote
> Hai,
> 
> Can anyone tell me the difference and performance between pgdump and
> pg_basebackup if I want to backup a large database.
> 
> Thanks

Yes.  And many of their words have been written down in the documentation in
a chapter named "Backup and Restore".  Do you have a specific question about
what is written there?

I'll add that comparing the performance of both is relatively meaningless.
You need to understand how each works then choose the correct tool for your
situation.

Lastly, you should actually do both, on a development database, and measure
the time and effort while practicing both routines (backup and restoring)
yourself.

David J.


--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-dump-vs-pg-basebackup-tp5797351p5797364.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


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