Index: FAQ.html
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/FAQ/FAQ.html,v
retrieving revision 1.130
diff -u -r1.130 FAQ.html
--- FAQ.html 2002/04/18 04:45:11 1.130
+++ FAQ.html 2002/04/25 13:20:01
@@ -81,6 +81,8 @@
clients" when trying to connect?
3.9) What are the pg_sorttempNNN.NN
files in my database directory?
+ 3.10) Why do I need to do a dump and restore
+ to upgrade PostgreSQL?
The PostgreSQL team tries very heard to maintain compatability across + minor releases. So upgrading from 7.2 to 7.2.1 does not require a dump a + restore. However, new features are continuously being adding and + sometimes this requires new fields to be added to system tables. + +
These changes may be across many tables and so maintaining backward + compatability would be quite difficult. Thus, restoring from a dump is + required to make everything work. + +
Note that the actual on-disk file format does not change very often, + a feature the pg_upgrade script uses quite successfully. There the dump + is used create the necessary information in the system tables. The data + files are then just copied across. This method is not as guarenteed as + the dump/restore method but when it works it can make upgrades very + efficient. +