CODEWITHSUNDEEP
postgresqlpostgresql-9.2pgadmin
Di Zou
Di Zou

Reputation: 4609

Where can I get pldbgapi.sql in order to install the debugger for postgresql?

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!

Upvotes: 14

Views: 20075

Answers (4)

Abderrahmen
Abderrahmen

Reputation: 506

For postgres 12, you should install this package using this commad:

apt-get install postgresql-12-pldebugger

There is no need to change the postgresql.conf file. You should also create this extension in the database that you will use for debugging:

CREATE EXTENSION pldbgapi;

I am using PGAdmin 4 for debugging PL/SQL procedures.

Upvotes: 2

shcherbak
shcherbak

Reputation: 788

This is included with EnterpriseDB distributive. You can download it on pgFoundry. here is a link

Also git repo is 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 on postgreql 9.5, works well.

Upvotes: 3

VictorMartinez
VictorMartinez

Reputation: 31

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

Upvotes: 3

HH321
HH321

Reputation: 552

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

Upvotes: 6

Related Questions