Re: Postgres upgrade from version 9.04 to 9.1.3

[Prashanth Ranjalkar <prashant.ranjalkar@xxxxxxxxx>]

On Mon, Jul 15, 2013 at 11:24 PM, Mónica Gamarra <monica.gamarra@xxxxxxxxx> 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.ranjalkar@xxxxxxxxx

Skype:prashanth.ranjalkar

Cell: +91 932 568 2271

www.postgresdba.net

Thanks 

--
............................................
Mónica Gamarra Barrios
monica.gamarra@xxxxxxxxx