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/plugin_debugger.so) 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)