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 EFBEAD1EBB8 for ; Fri, 26 Mar 2004 20:26:28 +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 50625-02 for ; Fri, 26 Mar 2004 16:26:33 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 5ACE3D1EBFE for ; Fri, 26 Mar 2004 16:26:25 -0400 (AST) Received: (qmail 20295 invoked by uid 500); 26 Mar 2004 20:29:39 -0000 Date: Fri, 26 Mar 2004 14:29:39 -0600 From: Bruno Wolff III To: "Mark M. Huber" Cc: Naomi Walker , pgsql-admin@postgresql.org Subject: Re: backup and recovery Message-ID: <20040326202939.GC20194@wolff.to> Mail-Followup-To: "Mark M. Huber" , Naomi Walker , pgsql-admin@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/356 X-Sequence-Number: 12925 On Mon, Mar 22, 2004 at 09:13:06 -0800, "Mark M. Huber" wrote: > That sounds like a brilliant idea, who do we say it to make it so? It might be better to make this part of pg_restore, rather than pg_dump. > > Mark H > > -----Original Message----- > From: Naomi Walker [mailto:nwalker@eldocomp.com] > Sent: Monday, March 22, 2004 8:19 AM > To: Mark M. Huber > Cc: Naomi Walker; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] backup and recovery > > > That brings up a good point. It would be extremely helpful to add two > parameters to pg_dump. One, to add how many rows to insert before a > commit, and two, to live through X number of errors before dying (and > putting the "bad" rows in a file).