Re: Upgrading Database: need to dump and restore? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Upgrading Database: need to dump and restore?
Date
Msg-id 2f4958ff0906031157v32fb9810j9476fd950e49491d@mail.gmail.com
Whole thread Raw
In response to Re: Upgrading Database: need to dump and restore?  ("Carlos Oliva" <carlos@pbsinet.com>)
List pgsql-general
On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva <carlos@pbsinet.com> 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

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: warm standby with WAL shipping
Next
From: Geoffrey
Date:
Subject: Re: warm standby with WAL shipping