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.
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.
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.
On Sat 22 Sep 2007, Dominic Hargreaves dom@earth.li wrote:
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.
Any progress on this?
Even if not, it might be worth updating the OGL "temporarily offline" message with the latest news, even if it's just "all the data is safe, and our experts are working on getting it into sync with the latest version of the database driver" or something like that. I'm mostly worried that the datestamp on the announcement is over a month old, and OGL is touted in several places as being the OpenGuides flagship, so it looks pretty bad for the project. So even a small update (and hence a bump to the announcement datestamp) would be a Good Thing.
Kake
On 10/10/2007, Kake L Pugh kake@earth.li wrote:
On Sat 22 Sep 2007, Dominic Hargreaves dom@earth.li wrote:
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.
Any progress on this?
I sent Dom an IRC message about it a while back but it may have vanished into the ether as these things do. I'll send a private email after this.
Even if not, it might be worth updating the OGL "temporarily offline" message with the latest news...
Yes, that's true. I've done this.
Thanks,
Earle.
On Thu, Oct 11, 2007 at 02:42:04PM +0100, Earle Martin wrote:
On 10/10/2007, Kake L Pugh kake@earth.li wrote:
On Sat 22 Sep 2007, Dominic Hargreaves dom@earth.li wrote:
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.
Any progress on this?
I sent Dom an IRC message about it a while back but it may have vanished into the ether as these things do. I'll send a private email after this.
Generally speaking, sending me a privmsg is a really bad way to get me to do something; even if I do happen to see it, unless I can act on it immediately it'll never get done.
Dominic.
openguides-dev@lists.openguides.org
-
Dominic Hargreaves -
Earle Martin -
Kake L Pugh