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

Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Imre Oolberg <imre(at)auul(dot)pri(dot)ee>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: 2011-01-03 18:56:48
Message-ID: 22730.1294081008@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Scott Ribe <scott_ribe(at)elevated-dev(dot)com> writes:
> Unless I misread his earlier post, he is starting the backup, copying files, stopping the backup, and expecting those transactions (between start & stop) to be applied, even though files changed during that time (including WAL files) have not all been copied. Again, unless I misread his earlier post, he is *not* copying WAL that was generated between start & stop.

If that's the case, it just plain won't work.  You can either shut down
the postmaster and copy a static set of files, or you can apply WAL to a
base backup that was taken from a live database.  There is no way to get
consistent results from a backup of a live database without applying all
the WAL that was generated while the backup was being taken.

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Imre OolbergDate: 2011-01-03 20:15:01
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Previous:From: Scott RibeDate: 2011-01-03 18:49:37
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal

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