Tuesday, March 29, 2005

An interesting life

This morning was stressful. I arrive, login to PGAdmin, and discover that 35 PostgreSQL databases are missing. My mind filled with "were we hacked?", "did the drive fail?", and so on. From the logs, I'm pretty sure we weren't hacked. The drives are chugging along fine - except for the block that glitched on a power fluctuation... that just happened to contain the PostgreSQL master object catalogue. In other words, PostgreSQL was dead!


Fortunately, I have a system that keeps 14-days of rolling backups. I took a dump of the current database (just in case), reinitialized the database (to be sure of NO corruption), and imported yesterday's backup. 2 hours later - 5 gigs of database is humming along well again. I love PostgreSQL. This is it's first glitch in 3.5 years, and it recovered with grace and ease.


In other news, I'm learning RSS/Atom. I have Firefox configured to show my friend's blogs/LJs/Whatever as folders on my bookmarks panel in Firefox. They update on their own. I'm probably going to add some news sources, Slashdot, and others too. It's really neat - they update themselves, so I can just check headlines without wasting a visit to the site. I'll definitely put an RSS feed on this site, soon.


Anyone object to being included in an RSS aggregator that lists all my friend's blogs/any others I find interesting and summarizes them on my site?
Mood: accomplished
Music: None

No comments: