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

BUG #3110: Online Backup introduces Duplicate OIDs

From: "Randy Isbell \(jisbell\)" <jisbell(at)cisco(dot)com>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: BUG #3110: Online Backup introduces Duplicate OIDs
Date: 2007-03-10 19:00:24
Message-ID: 0D5300131537E744BCB4C10DDCA27BE1017C9024@xmb-sjc-21e.amer.cisco.com (view raw or flat)
Thread:
Lists: pgsql-bugs
A bit more information.  

I found that if I take an offline backup created around the same time as my online backup, roll forward the transaction log files included in the offline backup using a recovery.conf file, the duplicate records do NOT exist.

Therefore it seems there is no corruption in the WAL files.  The problem must be in the PITR processing of the online backup file.

- r.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-03-10 23:02:12
Subject: Re: BUG #3110: Online Backup introduces Duplicate OIDs
Previous:From: Tom LaneDate: 2007-03-10 17:30:08
Subject: Re: alter column type (from timestamp to date) violates not null

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