Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7D2582E31E6 for ; Wed, 16 Jan 2008 10:59:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 11904-05 for ; Wed, 16 Jan 2008 10:59:37 -0400 (AST) Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 205A62E318C for ; Wed, 16 Jan 2008 10:59:43 -0400 (AST) Received: from [192.168.1.226] (or-69-34-217-90.sta.embarqhsd.net [69.34.217.90]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m0GExniV011001 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 16 Jan 2008 06:59:50 -0800 Message-ID: <478E1BDD.1060808@commandprompt.com> Date: Wed, 16 Jan 2008 06:59:41 -0800 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Brian Modra CC: pgsql-admin@postgresql.org Subject: Re: Backup of live database References: <5a9699850801152257g6ee9513i6c4fc88a5f20a785@mail.gmail.com> <478DAC1D.3010909@commandprompt.com> <5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com> <478DBAC3.8050802@commandprompt.com> <5a9699850801160024y7abdcd2fjdb1035c2070797eb@mail.gmail.com> In-Reply-To: <5a9699850801160024y7abdcd2fjdb1035c2070797eb@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Wed, 16 Jan 2008 06:59:50 -0800 (PST) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/182 X-Sequence-Number: 27956 Brian Modra wrote: > Sorry to be hammering this point, but I want to be totally sure its OK, > rather than 5 months down the line attempt to recover, and it fails... > > Are you absolutely certain that the tar backup of the file that changed, > is OK? Have you considered testing it? Sincerely, Joshua D. Drake