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.
declare r record;
for r in select loid from pg_catalog.pg_largeobject loop
execute 'ALTER LARGE OBJECT ' || r.loid || ' OWNER TO owners_username';