Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group