RE: Issues with using plpgsql debugger using PG13 on Centos 7

Thank you for the pointer. We were able to build it correctly after setting the PG-13 path
PATH=$PATH:/usr/pgsql-13/bin

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
Sent: Tuesday, February 2, 2021 2:54 AM
To: Jain, Ankit <Ankit(dot)Jain(at)snapon(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Issues with using plpgsql debugger using PG13 on Centos 7

CAUTION: This email originated from outside of Snap-on. Do not click on links or open attachments unless you have validated the sender, even if it is a known contact. Contact the sender by phone to validate the contents.
2021年2月2日(火) 12:06 Jain, Ankit <Ankit(dot)Jain(at)snapon(dot)com<mailto:Ankit(dot)Jain(at)snapon(dot)com>>:
(...)
But got the following error –
ERROR: could not load library "/usr/pgsql-13/lib/plugin_debugger.so": /usr/pgsql-13/lib/plugin_debugger.so: undefined symbol: LWLockAssign SQL state: 58P01

Can you please help with getting the debugger working ?

It looks like the extension code was compiled against an older PostgreSQL
version (presumably 9.5 or earlier; LWLockAssign was removed in 9.6).

You'll need to make sure it's compiled against the major version you're using.

Regards

Ian Barwick

--
EnterpriseDB: https://www.enterprisedb.com<https://urldefense.com/v3/__https:/www.enterprisedb.com__;!!Lf_9VycLqA!wy8Xt5SI_nkVMC9Dq-R09xxO1WchcfRW8jcZjq4_qf8tzl1GQ5ZcajoSJQ1DY1M8$>