Mon Jan 14 08:53:44 PST 2008
- Previous message: [Slony1-general] What is the risk from running pg_dump on a replica
- Next message: [Slony1-general] What is the risk from running pg_dump on a replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [Slony1-general] What is the risk from running pg_dump on a replica
- Next message: [Slony1-general] What is the risk from running pg_dump on a replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list