Re: plpgsql.so undefined symbol error in pg_upgrade check - Mailing list pgsql-admin

From Tom Lane
Subject Re: plpgsql.so undefined symbol error in pg_upgrade check
Date
Msg-id 23034.1471550973@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql.so undefined symbol error in pg_upgrade check  (Mark Steben <mark.steben@drivedominion.com>)
Responses Re: plpgsql.so undefined symbol error in pg_upgrade check  (Mark Steben <mark.steben@drivedominion.com>)
List pgsql-admin
Mark Steben <mark.steben@drivedominion.com> writes:
> I am planning a 9.,2 to 9.4 upgrade using pg_upgrade with the link option.
> Thanks first to Tom Lane for the prompt answer last week.  I have installed
> 9.4 in the same disk as 9.2 and running pg_upgrade with the --check option
> I get this error:

> ERROR:  could not load library
> "/usr/local/pgsql_production/lib/plpgsql.so":
> /usr/local/pgsql_production/lib/plpgsql.so: undefined symbol: errcontext

This would seem to indicate that you are trying to load a 9.2 library into
the 9.4 server or vice versa.  You really need to have different lib
directories, as well as different bin directories, for the two versions.

            regards, tom lane


pgsql-admin by date:

Previous
From: Mark Steben
Date:
Subject: plpgsql.so undefined symbol error in pg_upgrade check
Next
From: Ravi Tammineni
Date:
Subject: What is the best way to create Primary Key on a large table in Postgresql 9.5?