How to debug Postgresql used by custom app

[ChristopherMag]

I have a custom application that is using the postgresql addon.

In troubleshooting issues that arise I would like to be able to debug functions I have created in postgresql.

I have installed pgAdmin 4 and have used the instructions here to connect to the database.

When I try to debug a function I get the following error "The debugger plugin is not enabled. Please create the pldbgapi extension in this database."

What steps can I take to enable the pldbgapi extension so that I can debug postgresql functions that are used by my cloudron app?

[nebulon]

I don't think it makes sense to support this. Cloudron is more of a deployment platform rather than development platform.

Debugging such things is probably be better done locally or in an environment which is set up for development.

[ChristopherMag]

Gotcha, given that the version of postgresql used in the addon is defined by the cloudron platform what would be the easiest way to run the same docker container version of postgresql used by the cloudron platform locally on my development system?

[nebulon]

The current addon uses 14.9 so I guess you could run the corresponding image from https://hub.docker.com/_/postgres