Not quite there yet

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/
plperl.so": libperl.so: cannot open shared object file: No such file or
directory

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
www.vmsinfo.com