Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 78F4E2E017D for ; Wed, 16 Jan 2008 18:56:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 38016-05 for ; Wed, 16 Jan 2008 18:56:31 -0400 (AST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 59CD02E00EE for ; Wed, 16 Jan 2008 18:56:31 -0400 (AST) Received: by wa-out-1112.google.com with SMTP id m38so742227waf.5 for ; Wed, 16 Jan 2008 14:56:29 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; bh=Bb21dlUTExV9ZLTZ4Klbd72rIC87a0TEdYmhY3hkhJA=; b=KutVpvEu8HvjUMfWAkAP+EXFBZvTg8qMj1a5551Q35wyDiVmg3R1UnmneEubwzVQy/mOjFQ5gA1n7tA2uBgJuac0HSiISZDb4ub4nRghvlIs2xbnPVq0nZYsn3QAPQiWYNhCNRDg9Pb7cdwERGEPSfEWg5xtkZcz7mZp29qWIkI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; b=YS8zFHXa89NgutHwTr2dlu6zJUNA1/uqjSplP9ttNVyN0h2fBPmsnuU17F1/X6ecAjjHuoeYof2VnViK2ri7wA3N1rOQzjmWq8aU9tdla3kwxwqRblTwUjngUGPOeT5AKpz5FHz3gymTLnVwGXyUvjmSYc3IybfVPVuYWt++uBk= Received: by 10.114.183.1 with SMTP id g1mr1583964waf.3.1200524189782; Wed, 16 Jan 2008 14:56:29 -0800 (PST) Received: from Blonder.sydney.atlassian.com ( [202.47.1.18]) by mx.google.com with ESMTPS id k21sm2164227waf.31.2008.01.16.14.56.28 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 16 Jan 2008 14:56:29 -0800 (PST) Message-Id: From: Tom Davies To: pgsql-admin@postgresql.org In-Reply-To: <478E4214.6030805@jobflash.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v915) Subject: Re: Backup of live database Date: Thu, 17 Jan 2008 09:56:25 +1100 References: <5a9699850801152257g6ee9513i6c4fc88a5f20a785@mail.gmail.com> <478DAC1D.3010909@commandprompt.com> <5a9699850801152310g39fa9bf3y3926892145ab3dcf@mail.gmail.com> <478DBAC3.8050802@commandprompt.com> <5a9699850801160024y7abdcd2fjdb1035c2070797eb@mail.gmail.com> <478E4214.6030805@jobflash.com> X-Mailer: Apple Mail (2.915) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/192 X-Sequence-Number: 27966 On 17/01/2008, at 4:42 AM, Tom Arthurs wrote: > The important thing is to start archiving the WAL files *prior* to > the first OS backup, or you will end up with an unusable data base. Why does the recovery need WAL files from before the backup? Tom