beer@xxxxxxx wrote:
Hi
I am trying to upgrade my database from 8.0 to 8.1 and am looking for a
little info/advice.
This is a production database that we are migrating and it is in CONSTANT
use, so the maintenance window must be small and hopefully mostly off-hours.
We use a PITR/LVM snapshot solution for our backups and were hoping to
simply restore the filesystem and startup under 8.1. Obviously this didnt
work, and I know the doc says a conversion is necessary, however I havent
found anything with enough detail to sway me from a better solution than
pg_restore.
Slony will let you replicate between different versions.
Given that you can't afford any downtime, and presumably don't want to
repeat this process in a hurry, I'd suggest going to 8.2, or 8.3 if you
can afford to wait a few weeks.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
