[OGDev] Help needed fixing the London database

Earle Martin openguides at downlode.org
Sat Sep 22 09:54:50 BST 2007


Hi,

A couple of weeks back OGL's Postgres installation was upgraded. I
made a dump of the database before that happened, but it seems to have
been in a slightly inconsistent state - key constraints broken in some
places, probably due to me removing enormous swathes of spam in a
rather brutal fashion. As a result, I can't currently restore it. I
tried commenting out the restraints in question in the dump before the
restore (which let it happen), and then locating and deleting the
errant nodes, but I obviously wasn't doing something right.

Could someone with more knowledge in this department please help me
out? I'm happy to give you a copy of the dump to test.

Thanks very much,

Earle.

-- 
Earle Martin
            http://downlode.org/
http://purl.org/net/earlemartin/



More information about the OpenGuides-Dev mailing list