Re: Backup of live database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tom Davies <tgdavies(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup of live database
Date: 2008-01-16 23:26:30
Message-ID: 29616.1200525990@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tom Davies <tgdavies(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-01-16 23:27:34 Re: Backup of live database
Previous Message Tom Lane 2008-01-16 23:25:02 Re: Strange client encoding issue