Postgres Pro
Downloads
Home   >   mailing lists

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

From Prashanth Ranjalkar
Subject Re: Postgres upgrade from version 9.04 to 9.1.3
Date
Msg-id CAMBytESh=EAVTNms8DxKVCgNNZi6XL3-bgjxE3ne+QSm2mCK=w@mail.gmail.com
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
Tree view

On Mon, Jul 15, 2013 at 11:24 PM, Mónica Gamarra <monica.gamarra@gmail.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
Skype:prashanth.ranjalkar
Cell: +91 932 568 2271
Thanks 

--
............................................
Mónica Gamarra Barrios
monica.gamarra@gmail.com

pgsql-admin by date:

Previous
From: Mónica Gamarra
Date:
Subject: Postgres upgrade from version 9.04 to 9.1.3
Next
From: Kevin Grittner
Date:
Subject: Re: 9.2.2 - semop hanging