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

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Imre Oolberg <imre(at)auul(dot)pri(dot)ee>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: 2010-12-30 15:10:49
Message-ID: 153FCB4B-D8B3-4011-B7A6-144CFC441AF5@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Dec 30, 2010, at 4:03 AM, Imre Oolberg wrote:

> 3. issued pg_start_backup('test') while script is still running

Well, yeah. Your procedure is going to get you a consistent snapshot of the state of the database when you issued that command.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jasen Betts 2010-12-30 18:49:49 Re: Finding missing values in sequence column
Previous Message Szymon Guz 2010-12-30 11:48:31 Re: Finding missing values in sequence column