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

-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

Unfortunately, I have functions written in plperl and plperlu.

--
http://mgogala.byethost5.com

Mladen Gogala wrote:

Do you have perl installed on the system? Make cannot find 'libperl.so'.

http://www.postgresql.org/docs/9.0/s...uirements.html

--
Fredrik Jonson

On Mon, 27 Sep 2010 05:55:58 +0000, Fredrik Jonson wrote:

Yes, I do have perl installed on the system. Problem is in the version.
When I point LD_LIBRARY_PATH to the proper directory, plperl complains
about the unresolved symbol for Dynaloader.



--
http://mgogala.byethost5.com

Mladen Gogala wrote:

With any common Linux distribution and derivatives like centos, you
almost always want to use a prepared package for the distributions
package manager. Your second preference should be building from
modified source packages (srpm:s). Only as a last option you want to
install from source.

One minute with a familiar search engine gave me this link:

http://pgrpms.org/

Another couple of minutes and I believe that the packages installed
from pgrpms.org will use /var/lib/pgsql/9.0/data as the default PGDATA
directory.

--
Fredrik Jonson

On Mon, 27 Sep 2010 18:37:28 +0000, Fredrik Jonson wrote:

I was able to successfully run pg_upgrade after compiling it from the
source. I will play with RPM packages over the weekend. Is pg_upgrade
included into the basic 9.0 RPM or needs to be installed from the source?



--
http://mgogala.byethost5.com