Re: Backup taking long time !!!

2017-01-20 12:53 GMT+01:00 Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>:

> Dear Pavel,
>
>
>
> Thanks for quick response.
>
> May I know how can I use physical full backup with export transaction
> segments.
>

https://www.postgresql.org/docs/9.1/static/continuous-archiving.html

This process can be automatized by some applications like barman
http://www.pgbarman.org/

Regards

Pavel

>
> *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:* Pavel Stehule [mailto:pavel(dot)stehule(at)gmail(dot)com]
> *Sent:* 20 January, 2017 5:19 PM
> *To:* Dinesh Chandra 12108 <Dinesh(dot)Chandra(at)cyient(dot)com>
> *Cc:* Madusudanan.B.N <b(dot)n(dot)madusudanan(at)gmail(dot)com>;
> pgsql-performance(at)postgresql(dot)org
>
> *Subject:* Re: [PERFORM] Backup taking long time !!!
>
>
>
> 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/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(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>
>
>
>
>
>