'Postgres Debugger cannot be configured in Windows 11

I am trying to configure the debugger in PostgreSQL 14.2 / PGAdmin 4. I change the postgresql.conf to shared_preload_libraries = '$libdir/plugin_debugger.dll'. The location of the file is correct. When I check the configuration from PGAdmin4, 'shared_preload_libraries' does not show up. I can add the extension pldbgabpi, but no debugger can be seen. What do I do wrong?

postgresqldebugging


Solution 1:[1]

The Debugger is available as an extension for your PostgreSQL installation and is distributed as part of Advanced Server. You must have superuser privileges to use the debugger.

as mentioned in article, your postgresql.conf would need a line like this

shared_preload_libraries = '$libdir/plugin_debugger.dll'

Don't forget that changing the postgresql.conf file will require a restart the server to apply the changes.

Reference: https://www.pgadmin.org/docs/pgadmin4/latest/debugger.html

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 PratikLad-MT

Related Questions