Re: plpgsql.so undefined symbol error in pg_upgrade check

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