Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 193DC2E312A for ; Wed, 16 Jan 2008 19:26:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 15165-06-4 for ; Wed, 16 Jan 2008 19:26:29 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4B1E02E3AD1 for ; Wed, 16 Jan 2008 19:26:32 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id m0GNQU6P029617; Wed, 16 Jan 2008 18:26:30 -0500 (EST) To: Tom Davies cc: pgsql-admin@postgresql.org Subject: Re: Backup of live database In-reply-to: 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> Comments: In-reply-to Tom Davies message dated "Thu, 17 Jan 2008 09:56:25 +1100" Date: Wed, 16 Jan 2008 18:26:30 -0500 Message-ID: <29616.1200525990@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/194 X-Sequence-Number: 27968 Tom Davies writes: > 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? It doesn't, but there's no reasonable way to start both processes at exactly the same instant, so the standard advice is to start archiving first. regards, tom lane