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.
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.