Skip site navigation (1) Skip section navigation (2)

Not quite there yet

From: Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Not quite there yet
Date: 2010-09-26 23:20:41
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
I downloaded the new PostgreSQL 9.0 and it isn't quite there yet:
-bash-3.2$ NEWDATADIR=`pwd`
-bash-3.2$ OLDBINDIR=/usr/bin
-bash-3.2$ NEWBINDIR=/opt/PostgreSQL/9.0/bin/
-bash-3.2$ pg_upgrade
Performing Consistency Checks
Checking old data directory (/var/lib/pgsql/data)           ok
Checking old bin directory (/usr/bin)                       ok
Checking new data directory (/opt/PostgreSQL/9.0/data)      ok
Checking new bin directory (/opt/PostgreSQL/9.0/bin)        ok
Checking for reg* system oid user data types                ok
Checking for /contrib/isn with bigint-passing mismatch      ok
Checking for large objects                                  ok
Creating catalog dump                                       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.0/data/loadable_libraries.txt".

-bash-3.2$ less /opt/PostgreSQL/9.0/data/loadable_libraries.txt
Failed to load library: $libdir/plperl
ERROR:  could not load library "/opt/PostgreSQL/9.0/lib/postgresql/": cannot open shared object file: No such file or

That means that the new version (EnterpriseDB binary installer) doesn't 
support plperl/plperlu . Unfortunately, I have functions written in 
plperl and plperlu. Playing with the new version will have to wait a bit.

Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251 


pgsql-novice by date

Next:From: Tom LaneDate: 2010-09-27 00:47:37
Subject: Re: Not quite there yet
Previous:From: Jean-Yves F. BarbierDate: 2010-09-26 21:26:41
Subject: retrieve function members types/domains <= types

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group