Postgres Pro
Downloads
Home   >   mailing lists

Thread: Postgres upgrade from version 9.04 to 9.1.3

Postgres upgrade from version 9.04 to 9.1.3

From
Mónica Gamarra
Date:
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.


Thanks 

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

Re: Postgres upgrade from version 9.04 to 9.1.3

From
Prashanth Ranjalkar
Date:

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

Re: Postgres upgrade from version 9.04 to 9.1.3

From
Bruce Momjian
Date:
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. +