Bruce Momjian wrote:
> In looking over how upgrades are documented, it seems we talk about
> dumping/reloading in two place in our documentation:
>
> Chapter 15. Installation from Source Code
> 15.4. Upgrading
> http://developer.postgresql.org/pgdocs/postgres/install-upgrading.html
>
> and:
>
> Chapter 24. Backup and Restore
> 24.4. Migration Between Releases
> http://developer.postgresql.org/pgdocs/postgres/migration.html
>
> The steps listed also use slightly different syntax, e.g. psql [-d], and
> we call one "migrating" and the other "upgrading".
>
> This really needs a cleanup. Any suggestions? I feel the two sections
> really need to be merged. Where should the combined section be placed?
I went ahead and merged those two sections and put it in:
Chapter 17. Server Setup and Operation
17.6. Upgrading a PostgreSQL Cluster
17.6.1. Upgrading Data via pg_dump
17.6.2. Other data migration methods
You can view the result here:
http://momjian.us/expire/pgsql.docs/upgrading.html
There seemed to be continual confusion over whether you need to
dump/reload, and I think it was because our upgrade instructions were
duplicative and not complete in both places. This should solve the
problem once and for all.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +