Hi 2017-01-20 12:43 GMT+01:00 Dinesh Chandra 12108 <dinesh.chan...@cyient.com>:
> Exactly parallel option is there in version 9.3 but I can’t upgrade new > version due to some concerns. > > Could you suggest in 9.1 how may I fix it. > 1. don't use it - you can use physical full backup with export transaction segments. or 2. buy faster IO Regards Pavel Stehule > > *Regards,* > > *Dinesh Chandra* > > *|Database administrator (Oracle/PostgreSQL)| Cyient Ltd. Noida.* > > *------------------------------------------------------------------* > > Mobile: +91-9953975849 <+91%2099539%2075849> | Ext 1078 > |dinesh.chan...@cyient.com > > Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India. > > > > *From:* Madusudanan.B.N [mailto:b.n.madusuda...@gmail.com] > *Sent:* 20 January, 2017 5:04 PM > *To:* Dinesh Chandra 12108 <dinesh.chan...@cyient.com> > *Cc:* pgsql-performance@postgresql.org > *Subject:* Re: [PERFORM] Backup taking long time !!! > > > > 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 <+91%2099539%2075849> | 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> > > >
