Woudl it be possible to keep the current postgresql version running in a different port, install a new version of postgresql, and copy the data from one version to the other while both versions are running? This might give us time to copy the tables and databases one at a time and reconfigure the database access for parts of the application until we complete the migration to the new version. ""Grzegorz Jaskiewicz"" <gryzman@xxxxxxxxx> wrote in message news:2f4958ff0906031157v32fb9810j9476fd950e49491d@xxxxxxxxxxxxxxxxx > On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva <carlos@xxxxxxxxxxx> wrote: >> Would I need to upgrade the entire cluster or can I just upgrade database >> wise? > Obviously whole installation has to be dumped and restored. Wether you > are going to dump database by database, or do pg_dumpall, is up to > you,and mainly depends on cluster size. > It's just that binary format of stored files changes from major > release to release, and postgresql will refuse to start with old > format data directory (where it stores all databases). > > -- > GJ > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
