PostgreSQL Debugger installation

Question

I'd like to debug functions and tried many online articles but couldn't help myself in installing Debugger for PostgreSQL.

I'm using below version:

"PostgreSQL 9.6.1 on x86_64-pc-mingw64, compiled by gcc.exe (Rev5, Built by MSYS2 project) 4.9.2, 64-bit"

Can someone please assist me in installing Debugger for PostgreSQL?

which articles have you looked at to save someone looking at the same ones ?pgadmin.org/docs/1.8/debugger.html — Gurmokh
– Gurmokh, Commented Mar 15, 2017 at 10:43

Laurenz Albe · Accepted Answer · 2017-03-15 15:13:46Z

2

Pull the latest source from https://git.postgresql.org/gitweb/?p=pldebugger.git and build it according to the instructions in the README.

You'll need a configured PostgreSQL source installation, but that shouldn't be a problem because you compiled PostgreSQL yourself, didn't you?

Here are the instructions and some remarks for building with MinGW on Windows.

edited Mar 15, 2017 at 15:13

answered Mar 15, 2017 at 11:19

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

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

2 Comments

Vikram Over a year ago

I'm complete new to Postgres. How do I access /contrib in windows? and copy the directory to this location.

Laurenz Albe Over a year ago

Oh, I thought you'd built it yourself. Where did you get MinGW binaries?

mtahatavaci · Accepted Answer · 2021-12-15 13:15:50Z

0

I am using postgresql 12 and pgadmin4 in my Microsoft Server. I tried to change postgresql config file (line 676) like:

shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll'

and then I restarted postgresql-x64-12 service and my server. But it didn't work out. Then I learned that I don't have to change the config file. I just need to create an extension on the database I need. Extension's name is "pldbgapi". I explained with the images below. You just need to create this extension and then right-click on your function and debug it.

Creating Extension (1)

Creating Extension (2)

Function Debuging

You can also create it with command line.

CREATE EXTENSION pldbgapi
SCHEMA public
VERSION "1.1";

edited Dec 15, 2021 at 13:15

answered Dec 15, 2021 at 13:09

mtahatavaci

12 bronze badges

Collectives™ on Stack Overflow

PostgreSQL Debugger installation

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related