Re: Postgres upgrade from version 9.04 to 9.1.3 - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Postgres upgrade from version 9.04 to 9.1.3
Date
Msg-id 20130716224509.GA2198@momjian.us
Whole thread Raw
In response to Postgres upgrade from version 9.04 to 9.1.3  (Mónica Gamarra <monica.gamarra@gmail.com>)
List 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@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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


pgsql-admin by date:

Previous
From: Eduardo
Date:
Subject: Re: 9.2.2 - semop hanging
Next
From: Javier Urbano Contreras
Date:
Subject: comparison schema/data