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. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
