PostgreSql PgAdmin4 Debug

Question

I tried to configure PgAdmin4 to use debug, following the manual, but something did not work, because an error as shown in this screenshot occurs:

I changed postgresql.conf to:

shared_preload_libraries = ‘$ libdir / other_libraries / plugin_debugger’

How should I install the requested pldbgapi extension on Linux / Ubuntu?

Thanks for any help.

@marc_s Thanks for the writing corrections.

Antonio José
– Antonio José

2019-10-11 14:55:51 +00:00
Commented Oct 11, 2019 at 14:55 — Antonio José
– Antonio José, Commented Oct 11, 2019 at 14:55

Thom Brown · Accepted Answer · 2019-10-11 16:08:08Z

1

To install an extension in a particular database, as it's requesting here, you need to either use the CREATE EXTENSION command in that database, or use PgAdmin 4's interface to install it.

Command method: Through whichever tool you wish, where you enter regular SQL commands, connect to the relevant database in question and run:

CREATE EXTENSION pldbgapi;

Or, in PgAdmin 4, open up the nodes for the database you want to install this extension for, right-click on "Extensions", then select Create > Extension... Now select pldbgapi from the drop-down list next to "Name" and click "Save".

You will need to repeat this process if you need the extension in additional databases within your cluster.

Disclosure: I am an EnterpriseDB (EDB) employee

edited Oct 11, 2019 at 16:08

answered Oct 11, 2019 at 15:12

Thom Brown

2,0698 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Antonio José Over a year ago

In PgAdmin 4, pldbapi does not appear in the list of available extensions. How to install pldbapi?

Thom Brown Over a year ago

If the pldbapi extension isn't listed, it will need to be installed through Synaptic Package Manager or apt-get. You'll see it listed as postgresql-(version)-pldebugger.

Antonio José Over a year ago

When trying to mark a breakpoint a new error occurs: The debugger plugin is not enabled. Please add the plugin to the shared_preload_libraries setting in the postgresql.conf file and restart the database server for indirect debugging.

Thom Brown Over a year ago

Assuming that the path is correct, yes, that would work, although it may be enough without a path, just 'plugin_debugger'.

Antonio José Over a year ago

Thom Brown, Thanks for helping and sharing your expertise.

|

Collectives™ on Stack Overflow

PostgreSql PgAdmin4 Debug

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related