Re: Backup taking long time !!!

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(dot)stehule(at)gmail(dot)com>
wrote:

> Hi
>
> 2017-01-20 12:43 GMT+01:00 Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)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(dot)chandra(at)cyient(dot)com
>>
>> Plot No. 7, NSEZ, Phase-II ,Noida-Dadri Road, Noida - 201 305,India.
>>
>>
>>
>> *From:* Madusudanan.B.N [mailto:b(dot)n(dot)madusudanan(at)gmail(dot)com]
>> *Sent:* 20 January, 2017 5:04 PM
>> *To:* Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>
>> *Cc:* pgsql-performance(at)postgresql(dot)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(dot)Chandra(at)cyient(dot)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(dot)chandra(at)cyient(dot)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>