pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres upgrade from version 9.04 to 9.1.3
3+ messages / 3 participants
[nested] [flat]
* Postgres upgrade from version 9.04 to 9.1.3
@ 2013-07-15 17:54 Mónica Gamarra <monica.gamarra@gmail.com>
2013-07-15 18:15 ` Re: Postgres upgrade from version 9.04 to 9.1.3 Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
2013-07-16 22:45 ` Re: Postgres upgrade from version 9.04 to 9.1.3 Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 3+ messages in thread
From: Mónica Gamarra @ 2013-07-15 17:54 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres upgrade from version 9.04 to 9.1.3
2013-07-15 17:54 Postgres upgrade from version 9.04 to 9.1.3 Mónica Gamarra <monica.gamarra@gmail.com>
@ 2013-07-15 18:15 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Prashanth Ranjalkar @ 2013-07-15 18:15 UTC (permalink / raw)
To: Mónica Gamarra <monica.gamarra@gmail.com>; +Cc: pgsql-admin
*
*
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*
*Email:prashant.ranjalkar@gmail.com*
*Skype:prashanth.ranjalkar*
*Cell: +91 932 568 2271*
*www.postgresdba.net*
> Thanks
>
> --
> ............................................
> Mónica Gamarra Barrios
> monica.gamarra@gmail.com
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Postgres upgrade from version 9.04 to 9.1.3
2013-07-15 17:54 Postgres upgrade from version 9.04 to 9.1.3 Mónica Gamarra <monica.gamarra@gmail.com>
@ 2013-07-16 22:45 ` Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2013-07-16 22:45 UTC (permalink / raw)
To: Mónica Gamarra <monica.gamarra@gmail.com>; +Cc: 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. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-07-16 22:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-07-15 17:54 Postgres upgrade from version 9.04 to 9.1.3 Mónica Gamarra <monica.gamarra@gmail.com>
2013-07-15 18:15 ` Prashanth Ranjalkar <prashant.ranjalkar@gmail.com>
2013-07-16 22:45 ` Bruce Momjian <bruce@momjian.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox