Even if pg_upgrade can be used, downtime can be significant. A dump and reload may be required if pg_upgrade can't be used with your database. C extension functions must be recompiled.
Upgrades can involve downtime and backward-compatibility-breaking changes.
The Amazon packages don't seem to get that, and just upgrade PostgreSQL. The documentation for upgrading a PostgreSQL cluster explains this point very clearly. This version policy may be weird and perhaps unwise, but it's also widely understood and something you would expect packagers to understand. It isn't see the PostgreSQL version policy, which makes it clear that the major version is "x.y", eg "9.1", "9.2", etc. Amazon's packages for PostgreSQL will upgrade from 9.1 to 9.2 as if that was a normal minor update.
0 kommentar(er)
