Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 621D49FB21B for ; Mon, 8 Jan 2007 11:45:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 43031-03 for ; Mon, 8 Jan 2007 11:45:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 699AF9FB219 for ; Mon, 8 Jan 2007 11:45:49 -0400 (AST) Received: (from root@localhost) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) id l08Fh2603187 for pgsql-admin@postgresql.org; Mon, 8 Jan 2007 09:43:02 -0600 (CST) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id l08FfID03016; Mon, 8 Jan 2007 09:41:18 -0600 (CST) Date: Mon, 8 Jan 2007 09:41:18 -0600 (CST) From: "Ben K." To: Simon Riggs cc: pgsql-admin@postgresql.org Subject: Re: PITR recovery In-Reply-To: <1168097862.3655.249.camel@silverbirch.site> Message-ID: References: <1168097862.3655.249.camel@silverbirch.site> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/62 X-Sequence-Number: 24218 > On Fri, 2007-01-05 at 12:59 -0600, Ben K. wrote: >> 2. sql dump and PITR >> Is it possible to use the PITR method with SQL dump? (pg_start_backup -> >> sql dump -> pg_stop_backup) I guess not, but just want to make sure. > > No, because there is no reason or benefit. Thanks. I guess the PITR plays on a different ground. This is just a superficial question, but would it be possible to separate sql and disk operations? Eventually, it would be nice if we can have something like these as example. (I don't have any experience with this product.) http://www.red-gate.com/products/SQL_Log_Rescue/ We sometimes have relatively minor but still painful problems (someone or some scripts causes undesirable changes) and if we can go from the sql dump (backup) and stop at a certain point, it would be really nice. It'd also give us more granuality in controlling backup or test servers. Regards, Ben K. Developer http://benix.tamu.edu