From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Steben <mark.steben@drivedominion.com>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: plpgsql.so undefined symbol error in pg_upgrade check
In-reply-to: 
 <CADyzmyx=BZpVFUehBGqmB1R87cELAFCGOPm-tScgV4N+rzSpOQ@mail.gmail.com>
References: 
 <CADyzmyx=BZpVFUehBGqmB1R87cELAFCGOPm-tScgV4N+rzSpOQ@mail.gmail.com>
Comments: In-reply-to Mark Steben <mark.steben@drivedominion.com>
	message dated "Thu, 18 Aug 2016 15:27:00 -0400"
Date: Thu, 18 Aug 2016 16:09:33 -0400
Message-ID: <23034.1471550973@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin