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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] De la part de DUPREZ Cédric Envoyé : mardi 4 octobre 2011 14:36 À : pgsql-general@xxxxxxxxxxxxxx Objet : Re: 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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] De la part de DUPREZ Cédric Envoyé : lundi 26 septembre 2011 16:13 À : pgsql-general@xxxxxxxxxxxxxx Objet : 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
