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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Here's an article I wrote for how to get one installed on Ubuntu.
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.