2014-03-25 15:56 GMT+01:00 Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx>:
Honestly,
On 03/25/2014 05:05 AM, Claudio Freire wrote:
On Tue, Mar 25, 2014 at 4:39 AM, David Johnston <polobo@xxxxxxxxx> wrote:
Hai,
Can anyone tell me the difference and performance between pgdump and
pg_basebackup if I want to backup a large database.
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
For large database it's possible also to consider , also, to change database status in backup mode and after take a snapshoot and returning to normal mode, saving also all archive after you finish the backup.
With that snapshoot you could easy mount it and restore on another machine or open in readonly mode (hot standby and after do a logical dump ) , a lot of storage have these capabilities and also filesystem or volume manager.
I think these is the fater option you have.
Mat Dba
