Re: Postgres upgrade from version 9.04 to 9.1.3

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Mónica Gamarra <monica(dot)gamarra(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres upgrade from version 9.04 to 9.1.3
Date: 2013-07-16 22:45:09
Message-ID: 20130716224509.GA2198@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Jul 15, 2013 at 02:54:03PM -0300, Mónica Gamarra wrote:
> Hello,
> I am planning to upgrade our databases from 9.0.4 to 9.1.3
> and I found a problem while upgrading one database that has
> many tablespaces. The upgrade fails with the following error
>
> "Cannot migrate to/from the same system catalog version
> when using tablespaces"
>
>
> Why 9.0.4 and 9.1.3 are same catalog version?
>
> Is there a workarround for this problem, I would like to avoid
> using a dmp.

You did something wrong as those versions use different catalog
versions.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Javier Urbano Contreras 2013-07-17 15:00:46 comparison schema/data
Previous Message Eduardo 2013-07-16 17:58:34 Re: 9.2.2 - semop hanging