Re: Restoring 8.0 db to 8.1

beer(at)cmu(dot)edu 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