使用VS 2012调试PostgrelSQL

欢迎转载，转载请标明出处：http://blog.csdn.net/notbaron/article/details/51100550

1 其他相关工具

l Perl安装

http://www.activestate.com/activeperl/downloads

l bsion、diff、gettext

http://gnuwin32.sourceforge.net/packages.html

l flex

http://www.postgresql.org/ftp/misc/winflex/

具体安装，蛤蟆已有笔记，大家查看即可。

l PostgrelSQl

http://www.postgresql.org/ftp/source/

l VS 2012

这个大家自己网上找个可用的版本吧，然后把安装路径加到PATH变量，

C:\Program Files (x86)\Microsoft VisualStudio 11.0\VC\bin

2 生成VS解决方案

到路径 ..\postgresql-9.5.2\src\tools\msvc

perl.exemkvcbuild.pl

Detected hardware platform: Win32

Generating win32ver.rc for src/backend

Generating win32ver.rc for src/timezone

Generating win32ver.rc forsrc/backend/snowball

Generating win32ver.rc forsrc/pl/plpgsql/src

Generating win32ver.rc for src/backend/replication/libpqwalreceiver

Generating win32ver.rc forsrc/interfaces/ecpg/pgtypeslib

Generating win32ver.rc forsrc/interfaces/ecpg/ecpglib

Generating win32ver.rc forsrc/interfaces/ecpg/compatlib

Generating win32ver.rc forsrc/interfaces/ecpg/preproc

Generating win32ver.rc forsrc/interfaces/ecpg/test

Generating win32ver.rc forsrc/test/isolation

Generating win32ver.rc for src/bin/initdb

Generating win32ver.rc for src/bin/pgbench

Files src/bin/pgbench/exprscan.l

Files src/bin/pgbench/exprparse.y

Generating win32ver.rc forsrc/bin/pg_archivecleanup

Generating win32ver.rc forsrc/bin/pg_config

Generating win32ver.rc forsrc/bin/pg_controldata

Generating win32ver.rc for src/bin/pg_ctl

Generating win32ver.rc forsrc/bin/pg_resetxlog

Generating win32ver.rc forsrc/bin/pg_test_fsync

Generating win32ver.rc forsrc/bin/pg_test_timing

Generating win32ver.rc forsrc/bin/pg_upgrade

Generating win32ver.rc for src/bin/psql

Files src/bin/psql/psqlscan.l

Generating win32ver.rc forsrc/bin/pg_basebackup

Generating win32ver.rc forsrc/bin/pg_rewind

Generating win32ver.rc for src/bin/pgevent

Generating win32ver.rc for src/bin/pg_dump

Generating win32ver.rc for contrib/pgcrypto

Generating win32ver.rc forcontrib/adminpack

Generating win32ver.rc forcontrib/auth_delay

Generating win32ver.rc forcontrib/auto_explain

Generating win32ver.rc forcontrib/btree_gin

Generating win32ver.rc forcontrib/btree_gist

Generating win32ver.rc for contrib/chkpass

Generating win32ver.rc for contrib/citext

Generating win32ver.rc for contrib/cube

Files contrib/cube/cubescan.l

Files contrib/cube/cubeparse.y

Generating win32ver.rc for contrib/dblink

Generating win32ver.rc for contrib/dict_int

Generating win32ver.rc forcontrib/dict_xsyn

Generating win32ver.rc forcontrib/earthdistance

Generating win32ver.rc for contrib/file_fdw

Generating win32ver.rc forcontrib/fuzzystrmatch

Generating win32ver.rc for contrib/hstore

Generating win32ver.rc for contrib/intarray

Generating win32ver.rc for contrib/isn

Generating win32ver.rc for contrib/lo

Generating win32ver.rc for contrib/ltree

Generating win32ver.rc for contrib/oid2name

Generating win32ver.rc forcontrib/pageinspect

Generating win32ver.rc forcontrib/passwordcheck

Generating win32ver.rc forcontrib/pgrowlocks

Generating win32ver.rc for contrib/pgstattuple

Generating win32ver.rc forcontrib/pg_buffercache

Generating win32ver.rc forcontrib/pg_freespacemap

Generating win32ver.rc forcontrib/pg_prewarm

Generating win32ver.rc forcontrib/pg_standby

Generating win32ver.rc for contrib/pg_stat_statements

Generating win32ver.rc for contrib/pg_trgm

Generating win32ver.rc forcontrib/postgres_fdw

Generating win32ver.rc for contrib/seg

Files contrib/seg/segscan.l

Files contrib/seg/segparse.y

Generating win32ver.rc for contrib/spi

Generating win32ver.rc forcontrib/tablefunc

Generating win32ver.rc for contrib/tcn

Generating win32ver.rc forcontrib/test_decoding

Generating win32ver.rc for contrib/tsearch2

Generating win32ver.rc forcontrib/tsm_system_rows

Generating win32ver.rc forcontrib/tsm_system_time

Generating win32ver.rc for contrib/unaccent

Generating win32ver.rc for contrib/vacuumlo

Generating win32ver.rc forsrc/test/modules/dummy_seclabel

Generating win32ver.rc forsrc/test/modules/test_ddl_deparse

Generating win32ver.rc forsrc/test/modules/test_parser

Generating win32ver.rc forsrc/test/modules/test_rls_hooks

Generating win32ver.rc forsrc/test/modules/test_shm_mq

Generating win32ver.rc forsrc/test/modules/worker_spi

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/ascii_and_mic

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/cyrillic_and_mi

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/euc_cn_and_mic

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/euc_jp_and_sjis

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/euc_kr_and_mic

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/euc_tw_and_big5

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/latin2_and_win1

250

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/latin_and_mic

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_ascii

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_big5

Generating win32ver.rc for src/backend/utils/mb/conversion_procs/utf8_and_cyrill

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_euc_cn

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_euc_jp

Generating win32ver.rc for src/backend/utils/mb/conversion_procs/utf8_and_euc_kr

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_euc_tw

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_gb1803

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_gbk

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_iso885

9_1

Generating win32ver.rc for src/backend/utils/mb/conversion_procs/utf8_and_johab

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_sjis

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_win

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_uhc

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_euc200

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/utf8_and_sjis20

Generating win32ver.rc forsrc/backend/utils/mb/conversion_procs/euc2004_sjis200

Generating win32ver.rc for src/bin/scripts

Generating win32ver.rc for src/test/regress

Generating win32ver.rc forsrc/bin/pg_xlogdump

Copying pg_config_os.h...

Generating pg_config.h...

Copying pg_config_ext.h...

Generating src/interfaces/ecpg/ecpglib/ecpglib.def...

Generatingsrc/interfaces/ecpg/compatlib/compatlib.def...

Generatingsrc/interfaces/ecpg/pgtypeslib/pgtypeslib.def...

Generating probes.h...

Generating errcodes.h...

Generating libpq.rc...

Generating ecpg_config.h...

Generating pg_config_paths.h...

在源码包的上层目录上生成VS解决方案

用VS打开后，编译；

也可以直接使用命令编译，执行buildDEBUG命令；

如果需要某些特性，如openssl支持，新建config.pl，然后加入$config->{openssl} ='openssl安装路径'，然后再执行

3 调试

使用VS打开解决方案，右键单击要调试的程序，例如initdb，选择属性->配置属性->调试，输入调试参数和工作目录，例如参数为-D，工作目录为d: \pgsqldata，最后确定；

右键点击要initdb->调试->进入并单步执行新实例，这样就可以调试initdb了。

4 错误

4.1 生成解决方案错误

Unable to determine Visual Studio version:The nmake version could not be determ ined. at Mkvcbuild.pm line 81.

答：注：2012版本的vsVersion为11.00，2010版本的vsVersion为10.00，而2008版本的vsVersion为9.00

将：

my $vsVersion =DetermineVisualStudioVersion();

改成

my $vsVersion = '11.00';

修改config.pl：

注释Config.pl文件中的如下内容：

#ldap => 1, # --with-ldap

#extraver => undef, # --with-extra-version=<string>

#nls => undef, # --enable-nls=<path>

#tap_tests => undef, #--enable-tap-tests

#tcl => undef, # --with-tls=<path>

#perl => undef, # --with-perl

#python => undef, # --with-python=<path>

#openssl => undef, # --with-openssl=<path>

#uuid => undef, #--with-ossp-uuid

#xml => undef, # --with-libxml=<path>

#xslt => undef, # --with-libxslt=<path>

#iconv => undef, # (not in configure, path to iconv)

#zlib => undef # --with-zlib=<path>

4.2编译错误

src/port/dirent.c : fatal errorC1902:程序数据库管理器不匹配；请检查安装

答：将mspdb110.dll文件从路径

C:\Program Files (x86)\Microsoft VisualStudio 11.0\VC\bin

删除。

该文件当时是为了使用cl.exe从下面路径复制过来的。

C:\Program Files (x86)\Microsoft VisualStudio 11.0\Common7\IDE

5 其他相关文档

http://wiki.postgresql.org/wiki/PgkernalDebugEnvironmentSetup

使用VS 2012调试PostgrelSQL