I hope you realise that 9.1 is EOLed - http://blog.2ndquadrant.com/ postgresql-9-1-end-of-life/
Which means that the version that you are using will not receive any updates which includes critical updates to performance and security. If I were you, I would work on the issues that stops me from upgrading, but that is my opinion. As pavel said, you could use a physical backup instead of pg dump. On Fri, Jan 20, 2017 at 5:18 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > 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/d >> ocs/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> >> >> >> > > -- Regards, Madusudanan.B.N <http://madusudanan.com>
