quasi random (kaolinfire) wrote,
quasi random

server failure, server upgrade

server failure, server upgrade, round and round it goes...

I think that one lasted almost exactly two years. Maybe two and change...no, wait, because it was migrated a while back, ... no, I don't know if the hardware changed.

Going from FreeBSD (32bit!?) to Ubuntu x64.

The hard drive didn't actually fail, but the power supply did, and then who knows what else...it wouldn't stay up for more than a few minutes.

I've had to jump through some hoops to get things going. Installing kmod-ufs to mount it on a _third_ server, rsyncing things over (and checking out my backup process in the...process...and seeing that it's lacking somewhat, though still miles better than it was!)

Today's biggest hurdle so far has been postgresql.

This Ubuntu comes with Postgresql 9.1. I was on 9.0. Postgresql is practically ANTI-compatible with any semi-major version. So I install 9.0 side-by-side from the source...no go. Oh, hey, I must have been running 32bit FreeBSD. 32bit postgresql! So I cross-compile postgresql 9.0 (win!) (except!) The magic upgrade still doesn't work. So I do a dump and restore...and still failure, because a very misguided youthful me did plpgsql functions in there, and the dump hardcoded the path to the associated .so... so I have to go through the dump and replace all those.

Okay, I think it might be good now. And I could go on. But it's 5am, and I'm feeling pretty good, and that's a danger sign with these things.... ;)

Yeah, it's 5am. And my server is now on eastern time. Okay. It probably was before. Or was supposed to be. Don't care. It can stay there.

Oh, hey, and more magic was necessary. Problems with blob ownership in postgresql. of course.

do $$
declare r record;
for r in select loid from pg_catalog.pg_largeobject loop
execute 'ALTER LARGE OBJECT ' || r.loid || ' OWNER TO owners_username';
end loop;

via http://doginpool.blogspot.com/2011/10/today-upgraded-to-new-ubuntu-11.html!
Tags: failure, freebsd, postgresql, server, server failure, ubuntu, upgrade

  • A year of poetry and fiction....

    It doesn't feel like much (I haven't been writing, mostly), and I've not been submitting like I need to, but somehow I managed to succeed…

  • GUD Issue 5--is ALIVE! :D

    What's not to love??? Issue 5 ... WRAPS A SCIENTIFIC CORE WITH OUR MOST ECLECTIC SELECTION TO DATE—including two "mini graphic novels", and a…

  • Preditors + Editors Readers' Poll

    Probably 9/10 of you have already either put your votes in or decided you're not interested, but this is my last-minute plea for the other two of…

  • Post a new comment


    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.