postgresql update mysteriously delayed

| No Comments | No TrackBacks
Well that was weird. I did a reboot of my little server to test out a new boot loader (migrating from grub-legacy to grub-pc) and this blog stopped working. First it couldn't connect to the database on the right port, and it seemed postgresql was running on a different port. Once I'd reconfigured postgresql to run on the old port, it seemed I had no data in the database.

I can't really explain it, but this must be an artifact of my upgrade to the Debian Squeeze release. The /usr/share/doc/postgresql-8.4/README.Debian.gz file says that the port defaults to 5433 if the 8.3 version of postgres is still installed. So maybe up until today I've been running 8.3 and 8.4. But I'm sure I did some reboots as part of the upgrade, so I don't see why the reboot today would have hit this.

Restoring the data from last nights backup got me going again. It's always important to have backups (and I'm glad I got my backup system in place a few weeks ago).

No TrackBacks

TrackBack URL: http://geoff-blog.cromp.id.au/cgi-bin/movabletype/mt-tb.cgi/145

Leave a comment

About this Entry

This page contains a single entry by Geoff Crompton published on March 14, 2011 4:15 PM.

Trinity iPad in the news was the previous entry in this blog.

sound fail is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Categories

Pages

Powered by Movable Type 4.35-en