-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi,
I am planning to replace Sun's PostgreSQL on ptolemy with our own Postgres package. If we stay with 8.3, this will only involve about 10 minutes downtime for the upgrade, and will be transparent to users. 8.3 is supported until February 2013, so there is no pressing need to upgrade.
However, it might make sense to upgrade to a more recent version at the same time; either 8.4 or 9.0. This will require a dump and reload of all databases, so it will take a while to complete. As far as I know, there should be no (or very few) changes required to tools using the database.
I don't have a strong opinion either way, although I think it makes sense to upgrade regularly rather than stay on the same version forever. Before I make a decision, it would be nice to know what people actually using the database think.
- river.