Обсуждение: plpgsql.so undefined symbol error in pg_upgrade check

Поиск
Список
Период
Сортировка

plpgsql.so undefined symbol error in pg_upgrade check

От
Mark Steben
Дата:
Good afternoon.  
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 is pointing to the old 9.2 setup.  Of course running with the --check option I have not shut down 9.2 nor started up 9.4.

Thanks for your time and attention.
 

--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089

t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com





Re: plpgsql.so undefined symbol error in pg_upgrade check

От
Tom Lane
Дата:
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


Re: plpgsql.so undefined symbol error in pg_upgrade check

От
Mark Steben
Дата:
Tom I do have two lib directories and and two bin directories but you were right
in that I was trying to load a 9.2 library into a 9.4 server.  I had a symlink pointing
to the 9.2 binaries.  Once I killed the symlink and recreated it pointing to the 9.4 binaries the problem went away.  Thanks for the insight. 

On Thu, Aug 18, 2016 at 4:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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



--
Mark Steben
 Database Administrator
@utoRevenue | Autobase 
  CRM division of Dominion Dealer Solutions 
95D Ashley Ave.
West Springfield, MA 01089

t: 413.327-3045
f: 413.383-9567

www.fb.com/DominionDealerSolutions
www.twitter.com/DominionDealer
 www.drivedominion.com