|
Hi, I am trying to setup the debugger plugin on Centos 7 where PG 13 server has been setup using the git repository located here -
https://git.postgresql.org/gitweb/?p=pldebugger.git;a=summary The OS version is CentOS Linux release 7.9.2009 (Core). However, after making the changes to postgresql.conf to reference the plugin_debugger.so library that was created on CentOS 7 using several variations to ensure that the .so file was being referenced - shared_preload_libraries = '/usr/lib64/pgsql/plugin_debugger' or shared_preload_libraries = 'plugin_debugger' or shared_preload_libraries = '/usr/pgsql-13/lib/plugin_debugger.so' I encountered the following error during postgres start up– -- Unit postgresql-13.service has begun starting up. Feb 01 21:53:20 myserver.com postmaster[22726]: 2021-02-02 02:53:20.482 GMT [22726] LOG: skipping missing configuration file "/data/pgdata/data/postgresql.auto.conf" Feb 01 21:53:20 myserver.com postmaster[22726]: 2021-02-01 21:53:20.485 EST [22726] FATAL: could not load library "/usr/lib64/pgsql/plugin_debugger.so": /usr/lib64/pgsql/plug Feb 01 21:53:20 myserver.com postmaster[22726]: 2021-02-01 21:53:20.486 EST [22726] LOG: database system is shut down Feb 01 21:53:20 myserver.com systemd[1]: postgresql-13.service: main process exited, code=exited, status=1/FAILURE Feb 01 21:53:20 myserver.com systemd[1]: Failed to start PostgreSQL 13 database server. -- Subject: Unit postgresql-13.service has failed -- Defined-By: systemd -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel -- -- Unit postgresql-13.service has failed. -- -- The result is failed. Feb 01 21:53:20 rich-arch-01-pp.ipa.snapbs.com systemd[1]: Unit postgresql-13.service entered failed state. Feb 01 21:53:20 rich-arch-01-pp.ipa.snapbs.com systemd[1]: postgresql-13.service failed. Though the library wasn’t loaded, I attempted to add the extension at the DB level using
CREATE EXTENSION pldbgapi; 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 ? Thanks Ankit |
