Log in

No account? Create an account

Previous Entry | Next Entry

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!


( 4 comments — Leave a comment )
(Deleted comment)
Oct. 19th, 2012 01:08 pm (UTC)
la la la thud? It's been a long day. Long couple of days, long week, though not all because of this (though the warning crack was there...)

This is my one and only, server-of-everything. If I have a site, other than my own personal website (for legacy reasons), it's on this server.

Though I did "let" a lot of folks go when the previous incarnation of it failed deader than dead about two and a half years ago.

(@*#$(*#@ remote servers....

I need to sleep. Can't seem to stand up. Still need to do mail (exim, dovecot, mailman, some tricky mysql integration I don't entirely remember for virtual smtp auth and imap....). But that can happen tomorrow. Or after I sleep. Right? :)
(Deleted comment)
Oct. 19th, 2012 08:22 pm (UTC)
In case it wasn't clear from my rambling, not tentacle. :) Though I'm sure you saw that go through its own hoops recently!
Oct. 19th, 2012 04:47 pm (UTC)
where does this server live?
Oct. 19th, 2012 08:21 pm (UTC)
It's with a smallish company ~ http://www.smarterdedicatedserver.com/
( 4 comments — Leave a comment )

Latest Month

February 2016


Page Summary

Powered by LiveJournal.com
Designed by chasethestars