Re: Backup of live database - Mailing list pgsql-admin

From Tom Lane
Subject Re: Backup of live database
Date
Msg-id 29616.1200525990@sss.pgh.pa.us
Whole thread Raw
In response to Re: Backup of live database  (Tom Davies <tgdavies@gmail.com>)
List pgsql-admin
Tom Davies <tgdavies@gmail.com> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange client encoding issue
Next
From: "Scott Marlowe"
Date:
Subject: Re: Backup of live database