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-07 16:34:04
Message-ID: 19935.1173285244@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Randy Isbell <jisbell(at)cisco(dot)com> writes:
> This is not a pg_dump.  I am performing an online backup ala the  
> "pg_start_backup()" and "pg_stop_backup()" mechanism.

Oh, OK.  Could we see the system columns (ctid,xmin,xmax,cmin,cmax) for
the rows with duplicated OIDs?  Also, would you look at the user data in
these rows and see if it's the same in each pair?  I'm wondering if the
pairs might be both old and new states of an UPDATE.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2007-03-07 21:54:45
Subject: Re: BUG #3110: Online Backup introduces Duplicate OIDs
Previous:From: ravishankarDate: 2007-03-07 07:18:18
Subject: BUG #3120: relation "pg_catalog.pg_user"

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