Contributed by dwc on from the “dump: The SQL” dept.
As a PostgreSQL user, I noticed the following message by mbalmer@:
PostgreSQL users, this is a reminder for you... OpenBSD 4.1 CD's are hitting the street and release date is approaching. The PostgreSQL database port was updated from the 8.1 series to the 8.2 series. To update you databases you must dump them and restore them after the update. I just wanted to remind you of this, when you updated your system and packages, it's to late to do the database dump...;)
Just to be completely clear on this, do a database dump BEFORE you perform an upgrade or reinstall. Once upon a time I blindly moved to a new version of PostgreSQL without doing this only to find I was hosed. Dumping first keeps the upgrade process as smooth as you've come to expect, and it's something you should do anyway!
Thanks for the heads up, Marc!
(Comments are closed)