Windows下调试PostGreSQL源码第一步 - 下载和编译源码、构造VS工程

àì夳堔傛蜴生んèń 2023-01-01 03:41 400阅读 0赞

PostGreSQL是开源的DBMS系统；源码可用于研究学习；下面来看一下；

先下载源码；ftp站点下载，[https://ftp.postgresql.org/pub/source/][https_ftp.postgresql.org_pub_source]

先下载安装Perl；因为PostGreSQL的源码是使用Perl来构建为VS工程 ；

安装的perl是 ActivePerl；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1][]

安装是选中添加环境变量；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 3][]

因为早期的源码量少，先下一个7.0看下；看样子不行；按资料9.x版本的源码，其tools文件夹下带有msvc文件夹，可构造为MSVC的工程；7.0无法构建为Windows下VC++的工程；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 4][]

看9.3.2版本；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 5][]

修改下面文件，vs版本相关行；

![20201231012746638.png][]

改为10.0看一下；

![20201231012756269.png][]

执行perl命令构造；错误，不支持的vs版本；

![20201231012814470.png][]

改为9.0，还是一样；

![20201231012826667.png][]

当前安装的VS是VS2010 Express版本；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 6][]

折腾一阵；

![2020123101284677.png][]

原来写错，要写为 10.00 或 9.00，不能是10.0.0；执行perl build后如下；看样子构建成功了；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 7][]

看一下第一级目录，vs的.sln和proj文件出来了；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 8][]

接下来为方便调试；需要用源码来编译安装PostGreSQL；如果直接用安装包安装的PostGreSQL是无法进行互动调试的；

折腾了一阵一直出下面错误；相关内容还不熟悉，下回再整；

![20201231012917848.png][]

用VS打开解决方案看一下；有数个文件夹不能打开；

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 9][]

看下共117个项目；

![20201231012937577.png][]

都是纯C语言的；

![20201231014221796.png][]

不知道从哪儿入手开始调试；下回再整；

[https_ftp.postgresql.org_pub_source]: https://ftp.postgresql.org/pub/source/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70]: /images/20221120/d7d486d341e24cb5b770a309d0beac96.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 1]: /images/20221120/32db9d40f7064743bee386930a7f1a26.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20201231012706999.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/2020123101271715.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20201231012727354.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20201231012737124.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[20201231012746638.png]: https://img-blog.csdnimg.cn/20201231012746638.png
[20201231012756269.png]: https://img-blog.csdnimg.cn/20201231012756269.png
[20201231012814470.png]: https://img-blog.csdnimg.cn/20201231012814470.png
[20201231012826667.png]: https://img-blog.csdnimg.cn/20201231012826667.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20201231012836615.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[2020123101284677.png]: https://img-blog.csdnimg.cn/2020123101284677.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20201231012855132.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 8]: https://img-blog.csdnimg.cn/20201231012907332.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[20201231012917848.png]: https://img-blog.csdnimg.cn/20201231012917848.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24_size_16_color_FFFFFF_t_70 9]: https://img-blog.csdnimg.cn/2020123101292845.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JjYm9ibzIxY24=,size_16,color_FFFFFF,t_70
[20201231012937577.png]: https://img-blog.csdnimg.cn/20201231012937577.png
[20201231014221796.png]: https://img-blog.csdnimg.cn/20201231014221796.png