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@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:      davidplatt@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  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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