I am trying to install the debugger for postgresql on Linux so I can use pgAdmin to debug my functions. I've set up my postgresql.conf file. However, I can't find pldbgapi.sql.
Postgresql is installed at /usr/pgsql-9.2/. The directory /usr/pgsql-9.2/share/ exists, but /usr/pgsql-9.2/share/contrib does not exist. Where can I find the file or download it?
Thanks!
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. After modifying the shared_preload_libraries parameter, restart the server to apply the changes.
To set a breakpoint at the first line of a program, right-click the name of the object you would like to debug, and select Set breakpoint from the Debugging sub-menu. The debugger window will open, waiting for another session to invoke the program.
I've found out it works if I run the contents of this file
share\extension\pldbgapi--1.0.sql
There is also this readme for the extension which mentions a different installation process, I haven't tried it
http://git.postgresql.org/gitweb/?p=pldebugger.git;a=blob_plain;f=README.pldebugger;hb=54d993c04809da7cda79013a55b679a615c7dce1
Excelent aport, only:
Edit your postgresql.conf file, and modify the shared_preload_libraries config option to look like:
shared_preload_libraries = '$libdir/plugin_debugger'
Restart PostgreSQL for the new setting to take effect.
Run the following command in the database or databases that you wish to debug functions in:
CREATE EXTENSION pldbgapi;
Restart PostgreSQL for the new setting to take effect. Finally you can debugg!!
I used in Postgres 9.4
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With