Excerpts from Greg Spiegelberg's message of mar ago 31 09:04:18 -0400 2010: > Probably questions best asked on hackers but I figure many are represented here. > Will there ever be a release where a dump-restore is not necessary? > Perhaps, at least, minor releases (e.g. 9.0 to 9.1) will not require a > dump-restore? 9.0 to 9.1 is not a minor release. 9.0.0 to 9.0.1 is a minor release, and this doesn't require a dump/reload, but it also doesn't have any new features. 9.0 to 9.1 is just as major as 8.4 to 9.0 is. (The rule is: a change in second digit is major release, a change in first digit is marketing pressure) You can upgrade in place using pg_upgrade from 8.4 to 9.0 (thus you don't need dump/reload). In general, it will be possible to migrate from one major version to the next with pg_upgrade starting with the 8.4-to-9.0 jump. -- Álvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin