Re: BUG #5642: pg_upgrade does not handle shared libraries for language handlers

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:bruce(at)momjian(dot)us]
Sent: Tuesday, September 07, 2010 9:54 PM
To: David Platt
Cc: pgsql-bugs(at)postgresql(dot)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: davidplatt(at)davidplatt(dot)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 <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +