Brad Nicholson bnichols at ca.afilias.info
Mon Jan 14 08:53:44 PST 2008
On Mon, 2008-01-14 at 11:34 -0500, Vivek Khera wrote:
> On Jan 14, 2008, at 9:06 AM, Brad Nicholson wrote:
> 
> > Sometimes the data only pg_dump will also fails with missing OID
> > warnings.
> 
> What conditions would cause this?  Do you dump your data with OIDs?   
> Are your schemas not 100% consistent?

I'm not sure what the cause is. 
 
Schemas are 100% consistent (an audit had been done prior).  Dump was
just a standard pg_dump with the data only falg, no OIDs.

> I've been doing dumps "split" dumps like this for a long time and  
> never had a failure, so I'm curious what conditions could cause it.

If I had to guess, I'd say that the way slony corrupts the schema is
sometimes tripping the santiy check in pg_dump, and sometimes it isn't.

-- 
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.




More information about the Slony1-general mailing list