If you can upgrade to a newer version, there is parallel pg dump. Documentation - https://www.postgresql.org/docs/current/static/backup-dump.html
Related blog - http://paquier.xyz/postgresql-2/postgres-9-3-feature-highlight-parallel-pg_dump/ Which can give significant speed up depending on your machine's I/O capabilities. On Fri, Jan 20, 2017 at 4:54 PM, Dinesh Chandra 12108 < dinesh.chan...@cyient.com> wrote: > Hi Expert, > > > > I have a database having size around 1350 GB, created in PostgreSQL-9.1 in > Linux platform. > > I am using pg_dump to take backup which takes around 12 hours to complete. > > Could you please suggest me how I can make my backup fast so that it > complete in less hours? > > > > Thanks in advance. > > > > *Regards,* > > *Dinesh Chandra* > > *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.* > > *------------------------------------------------------------------* > > Mobile: +91-9953975849 | Ext 1078 |dinesh.chan...@cyient.com > > Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. > > > > ------------------------------ > > DISCLAIMER: > > This email message is for the sole use of the intended recipient(s) and > may contain confidential and privileged information. Any unauthorized > review, use, disclosure or distribution is prohibited. If you are not the > intended recipient, please contact the sender by reply email and destroy > all copies of the original message. Check all attachments for viruses > before opening them. All views or opinions presented in this e-mail are > those of the author and may not reflect the opinion of Cyient or those of > our affiliates. > -- Regards, Madusudanan.B.N <http://madusudanan.com>
