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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
