PostgreSQL 安装断点调试模块 pldebugger
以前写过一篇PostgreSQL 函数调试环境搭建的文章
《PostgreSQL 9.1.3 plpgsql debugger module》http://www.linuxidc.com/Linux/2012-07/66930.htm
源码来源比较老, 很多PG的代码都搬到github上面了, 其中也包含了pldebugger, 这篇BLOG还是讲函数调试环境的搭建, 只是从GITHUB上弄pldebugger的源码.
1. 首先要安装git客户端,
git的安装参考
《git install》 http://www.linuxidc.com/Linux/2012-07/66931.htm
2. 获取源码
[root@db-172-16-3-33 soft_bak]# git clone git://git.postgresql.org/git/pldebugger.git Cloning 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. 安装(测试时使用的是PostgreSQL 9.2 beta2源码)
mv pldebugger $PG_SRC/contrib/ cd $PG_SRC/contrib/pldebugger export PGHOME=/opt/pgsql export PATH=$PGHOME/bin:$PATH make sudo make install
3. 加载模块
digoal@localhost-> psql psql (9.2beta2) Type "help" for help. digoal=> \c digoal postgres You are now connected to database "digoal" as user "postgres". digoal=# create extension pldbgapi; CREATE EXTENSION
4. 调试plpgsql函数
略,
参见http://www.linuxidc.com/Linux/2012-07/66930.htm
相关推荐
WanKaShing 2020-11-12
zhbvictor 2020-10-29
kls00 2020-10-15
89921334 2020-07-29
83911930 2020-07-28
89407707 2020-06-27
89921334 2020-06-26
89244553 2020-06-21
84593973 2020-06-21
83911930 2020-06-16
yaoding 2020-06-14
89244553 2020-06-11
89407707 2020-06-11
89921334 2020-06-10
89407707 2020-06-10
goodriver 2020-06-09
kevinli 2020-06-06
84593973 2020-06-05