Could someone clarify the database dump/restore requirement for postgres upgrades between major releases?
The online help chapter “23.5. Migration Between Releases” states that:
As a general rule, the internal data storage format is subject to change between major releases of PostgreSQL (where the number after the first dot changes). This does not apply to different minor releases under the same major release (where the number after the second dot changes); these always have compatible storage formats. For example, releases 7.2.1, 7.3.2, and 7.4 are not compatible, whereas 7.2.1 and 7.2.2 are.
I thought that the major release was the first number in the versioning schema, the second represented minor release, and the third would be the maintenance release or revision number (i.e. 8.2.4). I need to understand this better for the sake of writing install scripts for my own Solaris packages. Originally, my scripts were checking for the difference in the major release between the output of “postgres –version” and PG_VERSION file, looking at the first module of the versioning schema (i.e. 8 in “8.2.4”). Is this still true, or should I be checking the minor release as well?
Thanks in advance,
~george