From: | DUPREZ Cédric <cedric(dot)duprez(at)ifn(dot)fr> |
---|---|
To: | DUPREZ Cédric <cedric(dot)duprez(at)ifn(dot)fr>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem with pg_upgrade from 9.0 to 9.1 under Ubuntu x64 |
Date: | 2011-10-04 15:25:07 |
Message-ID: | 5EB13D1B2A28494FBA69E90063F4ED84299030@populus3.ifn.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have solved the problem...
I had to rebuild postgis with postgresql 9.1.0 started (which was not the case).
Everything works fine, now. Pg_upgrade completed successfully.
Sorry for the disturbance.
Cedric Duprez
-----Message d'origine-----
De : pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] De la part de DUPREZ Cédric
Envoyé : mardi 4 octobre 2011 14:36
À : pgsql-general(at)postgresql(dot)org
Objet : Re: [GENERAL] Problem with pg_upgrade from 9.0 to 9.1 under Ubuntu x64
Hi,
I have partially solved the problem.
Now, I get the following error message:
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions ok
Checking database user is a superuser ok
Checking for prepared transactions ok
Checking for reg* system oid user data types ok
Checking for contrib/isn with bigint-passing mismatch ok
Creating catalog dump ok
Checking for prepared transactions ok
Checking for presence of required libraries fatal
| Your installation references loadable libraries that are missing
| from the new installation. You can add these libraries to
| the new installation, or remove the functions using them
| from the old installation. A list of the problem libraries
| is in the file
| "/opt/postgreSQL/9.1/bin/loadable_libraries.txt".
Failure, exiting
The loadable_libraries.txt file contains :
Failed to load library: $libdir/postgis-1.5
ERROR: could not load library "/opt/postgreSQL/9.1/lib/postgresql/postgis-1.5.so": /opt/postgreSQL/9.1/lib/postgresql/postgis-1.5.so: undefined symbol: DirectFunctionCall4
I have tried to rebuild postgis 1.5.3 many times, but I still get the same error message.
Can you help me ?
Thanks in advance,
Cedric Duprez
-----Message d'origine-----
De : pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] De la part de DUPREZ Cédric
Envoyé : lundi 26 septembre 2011 16:13
À : pgsql-general(at)postgresql(dot)org
Objet : [GENERAL] Problem with pg_upgrade from 9.0 to 9.1 under Ubuntu x64
Hi all,
I have a Linux/Ubuntu (10.04) x64 server on which I have installed PostgreSQL 9.0.4 by source compilation.
I have also installed PostgreSQL 9.1.0 with source compilation on the same server, and I try to migrate my data using pg_upgrade.
For PostgreSQL 9.0.4, the installation directories are :
- bindir : /opt/postgreSQL/9.0/bin/
- datadir : opt/postgreSQL/9.0/data/
- port : 5433 (specified in postgresql.conf)
For PostgreSQL 9.1.0, the installation directories are :
- bindir : /opt/postgreSQL/9.1/bin/
- datadir : opt/postgreSQL/9.1/data/
- port : 5433 (specified in postgresql.conf)
Both PostgreSQL server are shut down before migration.
I have compiled pg_upgrade 9.1 from the contrib source of PosgreSQL 9.1.0.
I use the following command :
/opt/postgreSQL/9.1/bin/pg_upgrade -v --old-datadir=/opt/postgreSQL/9.0/data/ --new-datadir=/opt/postgreSQL/9.1/data/ --old-bindir=/opt/postgreSQL/9.0/bin/ --new-bindir=/opt/postgreSQL/9.1/bin/ --old-port=5433 --new-port=5432 --user=postgres
And get the following message :
Running in verbose mode
Performing Consistency Checks
-----------------------------
Checking current, bin, and data directories ok
Checking cluster versions
This utility can only upgrade to PostgreSQL version 9.1.
Failure, exiting
Why do I get this error ?
Thanks in advance for your help,
Cedric Duprez
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2011-10-04 15:32:17 | Re: Streaming Replication and Firewall |
Previous Message | Alexander Farber | 2011-10-04 15:11:30 | LAPP server moving from 4 GB RAM to 16 GB - increase shared_buffers? |