Re: Upgrading Database: need to dump and restore?

From: "Carlos Oliva" <carlos(at)pbsinet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrading Database: need to dump and restore?
Date: 2009-06-03 19:03:38
Message-ID: h06hec$2ftd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)com> wrote in message
news:2f4958ff0906031157v32fb9810j9476fd950e49491d(at)mail(dot)gmail(dot)com(dot)(dot)(dot)
> On Wed, Jun 3, 2009 at 5:11 PM, Carlos Oliva <carlos(at)pbsinet(dot)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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey 2009-06-03 19:07:08 Re: warm standby with WAL shipping
Previous Message Grzegorz Jaśkiewicz 2009-06-03 18:57:27 Re: Upgrading Database: need to dump and restore?