pg_upgrade only to 9.0 ?

Started by Iain Barnettalmost 15 years ago6 messagesgeneral
Jump to latest
#1Iain Barnett
iainspeed@gmail.com

Hi,

I'm currently running 8.4.4. I downloaded the source for 9.0.4 and installed it, and then installed pg_upgrade and ran it, and got the following message:

This utility can only upgrade to PostgreSQL version 9.0.

It seems strange to me that it can only upgrade to that and not 4 patch points above, but still, so I go to the source directory to download 9.0 and it isn't listed.

Could anyone tell me how I'm supposed to get this to work please? I'd be really grateful.

Regards,
Iain

#2Scott Marlowe
scott.marlowe@gmail.com
In reply to: Iain Barnett (#1)
Re: pg_upgrade only to 9.0 ?

On Mon, May 9, 2011 at 6:10 PM, Iain Barnett <iainspeed@gmail.com> wrote:

Hi,

I'm currently running 8.4.4. I downloaded the source for 9.0.4 and installed it, and then installed pg_upgrade and ran it, and got the following message:

This utility can only upgrade to PostgreSQL version 9.0.

It seems strange to me that it can only upgrade to that and not 4 patch points above, but still, so I go to the source directory to download 9.0 and it isn't listed.

Could anyone tell me how I'm supposed to get this to work please? I'd be really grateful.

How did you run it? i.e. what exactly did you type in to run it?

#3Iain Barnett
iainspeed@gmail.com
In reply to: Scott Marlowe (#2)
Re: pg_upgrade only to 9.0 ?

On 10 May 2011, at 01:16, Scott Marlowe wrote:

On Mon, May 9, 2011 at 6:10 PM, Iain Barnett <iainspeed@gmail.com> wrote:

Hi,

I'm currently running 8.4.4. I downloaded the source for 9.0.4 and installed it, and then installed pg_upgrade and ran it, and got the following message:

This utility can only upgrade to PostgreSQL version 9.0.

It seems strange to me that it can only upgrade to that and not 4 patch points above, but still, so I go to the source directory to download 9.0 and it isn't listed.

Could anyone tell me how I'm supposed to get this to work please? I'd be really grateful.

How did you run it? i.e. what exactly did you type in to run it?

Sorry, ignore me, I wasn't following the instructions given here properly.
http://developer.postgresql.org/pgdocs/postgres/pgupgrade.html

Feel free to give me a slap via email for skimming documents and asking stupid questions! Thanks for making the effort though.

Regards,
Iain

#4Bruce Momjian
bruce@momjian.us
In reply to: Iain Barnett (#1)
Re: pg_upgrade only to 9.0 ?

Iain Barnett wrote:

Hi,

I'm currently running 8.4.4. I downloaded the source for 9.0.4 and
installed it, and then installed pg_upgrade and ran it, and got the
following message:

This utility can only upgrade to PostgreSQL version 9.0.

It seems strange to me that it can only upgrade to that and not 4 patch
points above, but still, so I go to the source directory to download
9.0 and it isn't listed.

Could anyone tell me how I'm supposed to get this to work please? I'd
be really grateful.

Very late reply, but can I see the command you are running? Odds are
you are pointing to 8.4 as the new database instead of 9.0.4.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

#5Marcos Cano
mcano@stsa.info
In reply to: Bruce Momjian (#4)
Re: pg_upgrade only to 9.0 ?

hello i'm having just a similiar problem, could you tell me what part of the
instructions you were missing?

im trying to upgrade from 8.3 to 9.2.4 but i get this error:

"this utility can only upgrade to postgresql version 9.2."

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-upgrade-only-to-9-0-tp4383292p5759508.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#6Bruce Momjian
bruce@momjian.us
In reply to: Marcos Cano (#5)
Re: pg_upgrade only to 9.0 ?

On Mon, Jun 17, 2013 at 10:44:44AM -0700, jmfox180 wrote:

hello i'm having just a similiar problem, could you tell me what part of the
instructions you were missing?

im trying to upgrade from 8.3 to 9.2.4 but i get this error:

"this utility can only upgrade to postgresql version 9.2."

You have to use the pg_upgrade version that matches the new server
version. I am confused by your report if you are upgrading to 9.0 or
9.2.

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general