Re: Postgres upgrade from version 9.04 to 9.1.3

From: Prashanth Ranjalkar <prashant(dot)ranjalkar(at)gmail(dot)com>
To: Mónica Gamarra <monica(dot)gamarra(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres upgrade from version 9.04 to 9.1.3
Date: 2013-07-15 18:15:29
Message-ID: CAMBytESh=EAVTNms8DxKVCgNNZi6XL3-bgjxE3ne+QSm2mCK=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

*
*
On Mon, Jul 15, 2013 at 11:24 PM, Mónica Gamarra
<monica(dot)gamarra(at)gmail(dot)com>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 can also consider slony for performing the upgrade if needed.

*

Thanks & Regards,*
*** *
*Prashanth Ranjalkar*
*Database Consultant & Architect*
*Email:prashant(dot)ranjalkar(at)gmail(dot)com*
*Skype:prashanth.ranjalkar*
*Cell: +91 932 568 2271*
*www.postgresdba.net*

> Thanks
>
> --
> ............................................
> Mónica Gamarra Barrios
> monica(dot)gamarra(at)gmail(dot)com
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2013-07-15 19:12:01 Re: 9.2.2 - semop hanging
Previous Message Mónica Gamarra 2013-07-15 17:54:03 Postgres upgrade from version 9.04 to 9.1.3