Postgres 8.4.1. The configure command was run with --prefix=/opt/postgres/8.4.1 and therefore the shared libraries are in /opt/postgres/8.4.1/lib. Same for 9.0rc1. The configure command was run with --prefix=/opt/postgres/9.rc1 and the shared libraries are in /opt/postgres/9.rc1/lib.
-----Original Message----- From: Bruce Momjian [mailto:br...@momjian.us] Sent: Tuesday, September 07, 2010 9:54 PM To: David Platt Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #5642: pg_upgrade does not handle shared libraries for language handlers David Platt wrote: > > The following bug has been logged online: > > Bug reference: 5642 > Logged by: David Platt > Email address: davidpl...@davidplatt.com > PostgreSQL version: 9.0 RC1 > Operating system: CentOS 5.5 > Description: pg_upgrade does not handle shared libraries for language > handlers > Details: > > The following definition is my database: > > CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler > LANGUAGE c > AS '/opt/postgres/8.4.1/lib/plpgsql', 'plpgsql_call_handler'; > > The file /opt/postgres/9.rc1/lib/plpgsql.o exists but the pg_upgrade run > fails on an error loading /opt/postgres/8.4.1/lib/plpgsql.o. What is the error? What old version of PG are you migrating from? -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
