Validation fails even though debug api is clearly present.

[lscoughlin]

** Description **
I setup the debugger in my plsql instance and enabled the extension, but on the IDEA side it think's it's not there.

To Reproduce
Install the debugger in pl/sql delivered by home-brew
Try and debug something in IntelliJ.

Expected behavior
I can debug in intellij

Screenshots

Desktop (please complete the following information):

• OS: macOS Sonoma
• Intellj: 2024.1.5
• postgresql 14
• debugger plugin: 241.0.1

[ng-galien]

Hi @lscoughlin

To resolve the issue, please ensure that the debugger is installed as a shared library on your PostgreSQL server. You can achieve this by adding the appropriate pldbgapi extension to the shared_preload_libraries in your postgresql.conf file. This setup is necessary for the plugin to function correctly.

For your convenience, I provide a pre-configured Docker image that includes the debugger extension. You can easily use this image with the following command:

docker run -p 5515:5432 --name PG15-debug -e POSTGRES_PASSWORD=postgres -d galien0xffffff/postgres-debugger:15

This image is based on the official PostgreSQL image and supports versions 11 to 16. More detailed instructions on how to set this up can be found in the README of the repository.

Let me know if you need further assistance!

Best regards,
Galien