Thread: FAQ suggestion: "How to upgrade from a previous release"

FAQ suggestion: "How to upgrade from a previous release"

From
Lincoln Yeoh
Date:
I think we may need something like this in the FAQ.

The pg download page says something like:
"NOTE: If upgrading from a version earlier than v7.0 an initdb will be
required"

Maybe the initdb could be linked to an explanation on how best to do it? And
whether it _could_ destroy data or not.

And there's something called pg_upgrade mentioned in the docs.

Meanwhile I'm not entirely sure what are the recommended upgrade methods. I
believe there are at least two depending on whether the db format has changed
or not.

Anyway I'd probably pg_dump my databases, install the new Pg, recreate
users, reload the databases.

Cheerio,
Link.