X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 819B2D1EC15 for ; Mon, 22 Mar 2004 16:19:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75028-03 for ; Mon, 22 Mar 2004 12:19:16 -0400 (AST) Received: from ecintweb.eldocomp.com (ecintweb.eldocomp.com [205.159.99.8]) by svr1.postgresql.org (Postfix) with ESMTP id 02694D1EC00 for ; Mon, 22 Mar 2004 12:19:06 -0400 (AST) Received: by ecintweb.eldocomp.com with XWall v3.29 ; Mon, 22 Mar 2004 09:19:15 -0700 From: Naomi Walker To: "Mark M. Huber" Cc: Naomi Walker , "pgsql-admin@postgresql.org" Subject: Re: backup and recovery Date: Mon, 22 Mar 2004 09:19:12 -0700 X-Assembled-By: XWall v3.29 X-Mailer: QUALCOMM Windows Eudora Version 5.1 Message-ID: <5.1.0.14.2.20040322091635.033ffd90@imap.eldocomp.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/283 X-Sequence-Number: 12852 That brings up a good point. It would be extremely helpful to add two=20 parameters to pg_dump. One, to add how many rows to insert before a=20 commit, and two, to live through X number of errors before dying (and=20 putting the "bad" rows in a file). At 10:15 AM 3/19/2004, Mark M. Huber wrote: >What it was that I guess the pg_dump makes one large transaction and our= =20 >shell script wizard wrote a perl program to add a commit transaction=20 >every 500 rows or what every you set. Also I should have said that we were= =20 >doing the recovery with the insert statements created from pg_dump. So...= =20 >my 500000 row table recovery took < 10 Min. > >Thanks for your help. > >Mark H > > >--------------------------------------------------------------------------= ----------------------------------------------- >Naomi Walker Chief Information Officer > Eldorado Computing, Inc. >nwalker@eldocomp.com 602-604-3100 >--------------------------------------------------------------------------= ----------------------------------------------- >Forget past mistakes. Forget failures. Forget everything except what you're >going to do now and do it. >- William Durant, founder of General Motors >--------------------------------------------------------------------------= ---------------------------------------------- > >-- CONFIDENTIALITY NOTICE -- > >This message is intended for the sole use of the individual and entity to= =20 >whom it is addressed, and may contain information that is privileged,=20 >confidential and exempt from disclosure under applicable law. If you are= =20 >not the intended addressee, nor authorized to receive for the intended=20 >addressee, you are hereby notified that you may not use, copy, disclose or= =20 >distribute to anyone the message or any information contained in the=20 >message. If you have received this message in error, please immediately=20 >advise the sender by reply email, and delete the message. Thank you. > >---------------------------(end of broadcast)--------------------------- >TIP 8: explain analyze is your friend ---------------------------------------------------------------------------= ---------------------------------------------- Naomi Walker Chief Information Officer Eldorado Computing, Inc. nwalker@eldocomp.com 602-604-3100 ---------------------------------------------------------------------------= ---------------------------------------------- Forget past mistakes. Forget failures. Forget everything except what you're= =20 going to do now and do it. - William Durant, founder of General Motors ---------------------------------------------------------------------------= --------------------------------------------- -- CONFIDENTIALITY NOTICE -- This message is intended for the sole use of the individual and entity to w= hom it is addressed, and may contain information that is privileged, confid= ential and exempt from disclosure under applicable law. If you are not the = intended addressee, nor authorized to receive for the intended addressee, y= ou are hereby notified that you may not use, copy, disclose or distribute t= o anyone the message or any information contained in the message. If you ha= ve received this message in error, please immediately advise the sender by = reply email, and delete the message. Thank you.