[OGDev] Help needed fixing the London database

[Dominic Hargreaves]

On Sat, Sep 22, 2007 at 09:54:50AM +0100, Earle Martin wrote:

> 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.

I'm no expert, but drop me a copy of the dump and let me know what
version of postgres you're trying to restore to, and I'll have a play.

Dominic.

-- 
Dominic Hargreaves | http://www.larted.org.uk/~dom/
PGP key 5178E2A5 from the.earth.li (keyserver,web,email)