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: (view raw, whole thread or download thread mbox)
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

			regards, tom lane

In response to


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-2017 The PostgreSQL Global Development Group