PostgreSQL installation breakpoint debugging module pldebugger

I have previously written an article titled PostgreSQL 9.1.3 plpgsql debugger module, which is set up in the PostgreSQL function debugging environment. The source code is old. Many PG code has been moved to github, including pldebugger, this BLOG is about the establishment of the function debugging environment, just getting the pldebugger source code from GITHUB. 1. first, install the git client. For git installation, refer to git install 2. obtain source code

[root@db-172-16-3-33 soft_bak]# git clone git://git.postgresql.org/git/pldebugger.gitCloning into 'pldebugger'...remote: Counting objects: 366, done.remote: Compressing objects: 100% (262/262), done.remote: Total 366 (delta 233), reused 171 (delta 104)Receiving objects: 100% (366/366), 158.87 KiB | 3 KiB/s, done.Resolving deltas: 100% (233/233), done.

2. Installation (PostgreSQL 9.2 beta2 source code is used for testing)

mv pldebugger $PG_SRC/contrib/cd $PG_SRC/contrib/pldebuggerexport PGHOME=/opt/pgsqlexport PATH=$PGHOME/bin:$PATHmakesudo make install

3. Load modules

digoal@localhost-> psqlpsql (9.2beta2)Type "help" for help.digoal=> \c digoal postgresYou are now connected to database "digoal" as user "postgres".digoal=# create extension pldbgapi;CREATE EXTENSION

4. debug the plpgsql function. For more information, see