This patch makes mention to use the newer pg_dump when migrating, as suggested by a few folks.
-- Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
Index: backup.sgml =================================================================== RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/backup.sgml,v retrieving revision 2.47 diff -c -r2.47 backup.sgml *** backup.sgml 29 Aug 2004 21:08:47 -0000 2.47 --- backup.sgml 30 Sep 2004 05:53:53 -0000 *************** *** 946,962 **** change between major releases of <productname>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.0.1, 7.1.2, and 7.2 are not compatible, whereas 7.1.1 and 7.1.2 are. When you update between compatible versions, you can simply replace the executables and reuse the data area on disk. Otherwise you need to <quote>back up</> your data and <quote>restore</> it on the new ! server, using <application>pg_dump</>. (There are checks in place ! that prevent you from doing the wrong thing, so no harm can be done ! by confusing these things.) The precise installation procedure is ! not the subject of this section; those details are in <xref ! linkend="installation">. </para> <para> --- 946,964 ---- change between major releases of <productname>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 should always have compatible storage formats. For example, releases 7.0.1, 7.1.2, and 7.2 are not compatible, whereas 7.1.1 and 7.1.2 are. When you update between compatible versions, you can simply replace the executables and reuse the data area on disk. Otherwise you need to <quote>back up</> your data and <quote>restore</> it on the new ! server, using <application>pg_dump</>. (It is strongly recommended that you ! use the <application>pg_dump</> program from the newer version of ! <productname>PostgreSQL</> to take advantage of any enhancements that may ! have occured. There are checks in place that prevent you from doing the ! wrong thing, so no harm can be done by confusing these things.) The precise ! installation procedure is not the subject of this section; those details ! are in <xref linkend="installation">. </para> <para>
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org