pg_upgrade not detecting version properly

From: Chris Ernst <cernst(at)zvelo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: pg_upgrade not detecting version properly
Date: 2012-10-10 03:50:22
Message-ID: 5074F07E.5090102@zvelo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi all,

I'm trying to test using pg_upgrade to go from 9.1.6 to 9.2.1 on Ubuntu
server 10.04. But when I run pg_upgrade, it tells me I can only run it
on 8.3 or later.

Old:
postgres=# SELECT version();
version

----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.6 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bit
(1 row)

New:
postgres=# SELECT version();
version

----------------------------------------------------------------------------------------------------------------
PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Ubuntu 4.4.3-4ubuntu5.1) 4.4.3, 64-bit
(1 row)

Yet when I try to run pg_upgrade:

$ /usr/lib/postgresql/9.2/bin/pg_upgrade -b /usr/lib/postgresql/9.1/bin/
-d /postgresql/9.1/main -B /usr/lib/postgresql/9.2/bin/ -D
/postgresql/9.2/main -k -c -v
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions
This utility can only upgrade from PostgreSQL version 8.3 and later.
Failure, exiting

Any idea what could be going on here?

Thank you in advance for your help.

- Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Willy-Bas Loos 2012-10-10 08:15:09 Re: something better than pgtrgm?
Previous Message Tom Lane 2012-10-10 02:03:47 Re: pgxs problem...

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2012-10-10 06:49:42 Re: replace plugins directory with GUC
Previous Message Noah Misch 2012-10-10 03:47:07 Re: Truncate if exists