From owner-freebsd-fs@FreeBSD.ORG Thu Mar 26 15:16:01 2009 Return-Path: Delivered-To: fs@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 32F4510656D7 for ; Thu, 26 Mar 2009 15:16:01 +0000 (UTC) (envelope-from karl@denninger.net) Received: from FS.denninger.net (wsip-70-169-168-7.pn.at.cox.net [70.169.168.7]) by mx1.freebsd.org (Postfix) with ESMTP id E90DE8FC18 for ; Thu, 26 Mar 2009 15:16:00 +0000 (UTC) (envelope-from karl@denninger.net) Received: from [127.0.0.1] (localhost [127.0.0.1]) by FS.denninger.net (8.14.3/8.13.1) with SMTP id n2QFG0TB099643 for ; Thu, 26 Mar 2009 09:16:01 -0600 (CST) (envelope-from karl@denninger.net) Received: from [127.0.0.1] [192.168.1.40] by Spamblock-sys (LOCAL); Thu Mar 26 09:16:01 2009 Message-ID: <49CB9C2E.8060401@denninger.net> Date: Thu, 26 Mar 2009 10:15:58 -0500 From: Karl Denninger User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: Peter Schuller References: <200903251820.54749.doconnor@gsoft.com.au> <200903251925.36108.doconnor@gsoft.com.au> <3.0.1.32.20090325072137.00ee6b48@sage-american.com> <3.0.1.32.20090326065337.00f081e0@sage-american.com> <3.0.1.32.20090326070807.00f081e0@sage-american.com> <200903261331.n2QDVd4b038485@lava.sentex.ca> <20090326140131.GA45201@hyperion.scode.org> <49CB8E74.9090508@denninger.net> <20090326145230.GC46345@hyperion.scode.org> <49CB97CD.2010303@denninger.net> <20090326151100.GA46864@hyperion.scode.org> In-Reply-To: <20090326151100.GA46864@hyperion.scode.org> Content-Type: multipart/mixed; boundary="------------090708050607050807000208" X-Antivirus: avast! (VPS 090325-0, 03/25/2009), Outbound message X-Antivirus-Status: Clean X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: "Jack L. Stone" , freebsd-stable@freebsd.org, fs@freebsd.org Subject: Re: support quality (Re: dump | restore fails: unknown tape headertype 1853384566) X-BeenThere: freebsd-fs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Filesystems List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Mar 2009 15:16:05 -0000 This is a multi-part message in MIME format. --------------090708050607050807000208 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Peter Schuller wrote: >> To add to this what SHOULD (ha!) work is to dump the database partition >> FIRST and THEN dump the Transaction Log partition. >> > > Depending on how the database works; specifically when old data in the > log may or may not be expunged. You could do this with PostgreSQL by > using it's PITR support for example. But to the extent that you have a > log which is only supposed to be used for internal reasons (such as > with pg by default), you'd likely be in trouble anyway unless you had > a specific reason to know that it is safe. > True. If the log rolls on you while you're taking the dumps you're DEAD. Both design and verification are important :) -- -- Karl Denninger karl@denninger.net --------------090708050607050807000208--