Re: Problem with pg_upgrade from 9.0 to 9.1 under Ubuntu x64 - Mailing list pgsql-general

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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] De la part de DUPREZ Cédric
Envoyé : lundi 26 septembre 2011 16:13
À : pgsql-general@postgresql.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general