Re: [PERFORM] Backup taking long time !!!
| От | julyanto SUTANDANG |
|---|---|
| Тема | Re: [PERFORM] Backup taking long time !!! |
| Дата | |
| Msg-id | CAGu3fER+B6dFk=7F+DEMPPOSerYZs0HZMOfVAkbKs5Gdi-B-mg@mail.gmail.com обсуждение исходный текст |
| Ответ на | [PERFORM] Backup taking long time !!! (Dinesh Chandra 12108 <Dinesh.Chandra@cyient.com>) |
| Ответы |
Re: [PERFORM] Backup taking long time !!!
Re: [PERFORM] Backup taking long time !!! |
| Список | pgsql-performance |
Hi Dinesh,
Best practice in doing full backup is using RSYNC, but before you can copy the DATADIR, you might you pg_start_backup to tell the server not to write into the DATADIR, because you are copying that data. After finished copy all the data in DATADIR, you can ask server to continue flushing the data from logs, by commanding pg_stop_backup. Remember, not to copy the XLOG dir.
There are another way more simpler, which is applying command pg_basebackup, which actually did that way in simpler version.
if you did pg_dump, you wont get the exact copy of your data, and you will take longer downtime to recover the backup data. By that way, recovering is only starting up the postgres with that copy.
Good luck!
Julyanto SUTANDANG
Equnix Business Solutions, PT
(An Open Source and Open Mind Company)
www.equnix.co.id
Pusat Niaga ITC Roxy Mas Blok C2/42. Jl. KH Hasyim Ashari 125, Jakarta Pusat
T: +6221 22866662 F: +62216315281 M: +628164858028
Caution: The information enclosed in this email (and any attachments) may be legally privileged and/or confidential and is intended only for the use of the addressee(s). No addressee should forward, print, copy, or otherwise reproduce this message in any manner that would allow it to be viewed by any individual not originally listed as a recipient. If the reader of this message is not the intended recipient, you are hereby notified that any unauthorized disclosure, dissemination, distribution, copying or the taking of any action in reliance on the information herein is strictly prohibited. If you have received this communication in error, please immediately notify the sender and delete this message.Unless it is made by the authorized person, any views expressed in this message are those of the individual sender and may not necessarily reflect the views of PT Equnix Business Solutions.
On Fri, Jan 20, 2017 at 6:24 PM, Dinesh Chandra 12108 <Dinesh.Chandra@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.chandra@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.
В списке pgsql-performance по дате отправления: