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
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... |
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 |