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

Re: BUG #3110: Online Backup introduces Duplicate OIDs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Randy Isbell <jisbell(at)cisco(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3110: Online Backup introduces Duplicate OIDs
Date: 2007-03-13 01:08:47
Message-ID: 16088.1173748127@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Randy Isbell <jisbell(at)cisco(dot)com> writes:
> One thing I do find interesting:  while the backup created with my  
> "online" / Chap 23.3 processing contains 18 WAL files, only the last  
> 3 (most recent) are used during the recovery process.  Is that normal?

Hmm, no, that seems pretty suspicious.  The thing *should* be starting
from the checkpoint created by pg_start_backup(), but that observation
makes it sound like it is starting from some later one, probably
whatever happened to be current when pg_control got archived.  Please
check this by noting what the startup messages say about where replay
commences, and compare to the backup label file (plain text, you can
just look at it) and pg_control (use pg_controldata before starting the
replay).

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Алексей ОпанасенкоDate: 2007-03-13 13:09:55
Subject: Installation bug
Previous:From: Magnus HaganderDate: 2007-03-12 19:00:22
Subject: Re: BUG #3131: on win pg_connect() is very slow

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