Mailing List Archive

When to upgrade postgresql db for 0.9.7.6 -> 0.9.8.3?
The hosted server I am running davical 0.9.7.6 on is still running Postgresql V8.1.18. If davical 0.9.8.X no longer supports PG V8.1 and I manage to convince the admins of the host to upgrade Postgresql to a later version, will I need to manually dump and reload the database to the new version or will the update-davical-database shell script do it?

I assume the correct sequence is to:
1. pg_dump the database contents,
2. upgrade to PG 8.2+,
3. reload the dump
4. upgrade awl
5. upgrade to davical 0.9.8.3
6. run update-davical-database shell script
7. run davical 0.9.8.3 to verify.

I assume davical 0.9.7.6 should not be run after reloading the dump at step 3.5?
--
Leigh M. Smith
mailto:leigh at leighsmith.com
http://www.leighsmith.com