February 28th, 2011 | Published in Database, Tech Talk | No Comments
Ok, so I’ve already corrected gaudy and horrible behavior [intlink id="postgresql-for-newbs"]part and parcel[/intlink] with default PostgreSQL installs, but what about that… other open-source SQL database? Is it wrong too? Sure is!
February 13th, 2011 | Published in Database, Tech Talk | 2 Comments
So you’ve decided to use PostgreSQL as the database for your sparkly new website running some variant of a LAMP stack. Or maybe you just got a new job and must now administer a PostgreSQL install so you excitedly did your research. You’ve read the install docs, tinkered on a VM, and you think you’ve got everything ready.
December 3rd, 2010 | Published in News, Tech Talk | No Comments
About a week ago, my website and email vanished off the face of the internet. I think this deserves a certain amount of explanation, lest someone think I’m incompetent in my own field. Not too long ago, I switched off my colocated server because I don’t need my own personal machine for two websites, a couple very small databases, and a low-volume email server.
June 3rd, 2010 | Published in Database, Tech Talk | No Comments
With the introduction of PostgreSQL 8.4, Bruce Momjian, a significant core developer, contributed a tool that can actually upgrade an entire database cluster in place. The time required is essentially only that necessary to copy the data files from the old installation to the new one. On a quick RAID system, this can be an order of magnitude faster than a dump/restore. The main drawback is similar to Slony: disk space must effectively be doubled for this upgrade method.
May 27th, 2010 | Published in News, Tech Talk | No Comments
I was fighting with packaging some software at work, trying to produce a workable RPM package to replace the manually installed kludge currently polluting one of our servers, and discovered the --spec-only option to the bdist_rpm action.
