Where can I get pldbgapi.sql to install a debugger for postgresql?

Question

I am trying to install a debugger for postgresql on Linux, so I can use pgAdmin to debug my functions. I configured the postgresql.conf file. However, I can not find pldbgapi.sql .

Postgresql is installed in /usr/pgsql-9.2/ . The /usr/pgsql-9.2/share/ directory exists, but /usr/pgsql-9.2/share/contrib does not exist. Where can I find a file or upload it?

Thank!

Answer 1

I found out that this works if I run the contents of this file

share\extension\pldbgapi--1.0.sql 

There is also this readme for an extension that mentions a different installation process, I have not tried it

http://git.postgresql.org/gitweb/?p=pldebugger.git;a=blob_plain;f=README.pldebugger;hb=54d993c04809da7cda79013a55b679a615c7dce1

Answer 2

Excelent aport, only:

• Modify the postgresql.conf file and change the configuration of shared_preload_libraries to look like this:

  shared_preload_libraries = '$ libdir / plugin_debugger'

• Restart PostgreSQL for the new parameter to take effect.

• Run the following command in the database or in the databases that you want the debug function:

  CREATE EXTENSION pldbgapi;

• Restart PostgreSQL for the new parameter to take effect. Finally you can debug.

I used in Postgres 9.4

Answer 3

This is included in the EnterpriseDB distribution. You can download it at pgFoundry. here's the link

Git repo is also available.

 git clone git://git.postgresql.org/git/pldebugger.git cd pldebugger export USE_PGXS=1 make make install 

Edit postgresql.conf

 vim /path/to/postgresql.conf 

add:

 shared_preload_libraries = 'plugin_debugger' 

Restart postgres, connect to db and call:

 CREATE EXTENSION pldbgapi; 

I use it in postgreql 9.5, works well.