What PL/pgSQL debugger can I use?

Question

I'm building a lot of PL/pgSQL functions and a debugger would really come in handy because RAISE NOTICE is not enough.

I read about a pgAdmin plugin you can install but it was only on Windows and I'm running Mac OS X.

Answer 1

Here's an article I wrote for how to get one installed on Ubuntu.

Installation instructions for the pldebugger for PostgreSQL

pg_config --version
"9.3beta2"

Look here for source code matching your version of PostgreSQL: ftp://ftp.postgresql.org/pub/source/

For me, it was:

wget ftp://ftp.postgresql.org/pub/source/v9.3beta2/postgresql-9.3beta2.tar.bz2
tar xvjf postgresql-9.3beta2.tar.bz2
cd postgresql
USE_PGXS=1 ./configure
USE_PGXS=1 make
cd contrib
git clone git://git.postgresql.org/git/pldebugger.git
make
cd pldebugger
USE_PGXS=1 make
sudo USE_PGXS=1 make install

These instructions assume that you have the development packages for your version of PostgreSQL already installed on your system.