It took me a while to figure out how to enable debugger for Postgresql server on Ubuntu. Initially I thought it was pre-packaged by Ubuntu therefore apt-get installed a few packages such as pgadmin3, pgadmin3-dev, postgresql-version.dbg.

Here is a post I wrote previously on this

Enable debug in PostgreSQL

The post is very easy to follow so I’m not duplicating it here. Just some my own notes to help understand at architecture level:

pgAdminIII runs on Windows

pgAdmin connects to Ubuntu server which hosts PostgreSQL server

The debugger(/usr/lib/postgresql/9.3/lib/ is enabled  in /etc/postgresql/9.3/main/postgresql.conf on PostgreSQL server

“CREATE EXTENSION pldbgapi” must be run on each individual database to enable debugging, and don’t forget to restart PostgreSQL server(sudo service postgresql restart)

Postgresql debugger

Leave a Reply

Your email address will not be published.

75 − 66 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.