摘要:坑是要有的,也是必须要跳的,但跳下去的时候,要勇敢的再爬上来.
首先确定一点Extension 中的Makefile错误是本文的根源.
make install时 下面是错误的输出结果:
me@me:~/Desktop/postgresql-10.1/contrib/test$ make install
make -C ../../src/interfaces/libpq all
make[1]: Entering directory '/home/me/Desktop/postgresql-10.1/src/interfaces/libpq'
make[1]: Nothing to be done for 'all'.
make[1]: Leaving directory '/home/me/Desktop/postgresql-10.1/src/interfaces/libpq'
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -I../../src/interfaces/libpq -I. -I. -I../../src/include -D_GNU_SOURCE -I/usr/include/libxml2 -c -o test.o test.c
test.c: In function ‘_PG_init’:
test.c:63:24: warning: assignment from incompatible pointer type [-Wincompatible-pointer-types]
my_ProcessUtility_hook= record_detable_info;
^
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -O2 -fPIC -shared -o test.so test.o -L../../src/port -L../../src/common -Wl,--as-needed -Wl,-rpath,'/opt/HighGo/postgresql10.1/lib',--enable-new-dtags -L../../src/interfaces/libpq -lpq
/bin/mkdir -p '/opt/HighGo/postgresql10.1/lib'
/bin/mkdir -p '/opt/HighGo/postgresql10.1/share/contrib'
/usr/bin/install -c -m 755 test.so '/opt/HighGo/postgresql10.1/lib/test.so'
/usr/bin/install -c -m 644 ./test--1.0.sql
/opt/HighGo/postgresql10.1/share/contrib/
黑体字copy错误: 按照正规路径应该是
/opt/HighGo/postgresql10.1/share/extension/
修改Makefile之前:
# contrib/test/Makefile
MODULE_big = test
OBJS = test.o
PG_CPPFLAGS = -I$(libpq_srcdir)
SHLIB_LINK = $(libpq)
SHLIB_PREREQS = submake-libpq
# the db name is hard-coded in the tests
override USE_MODULE_DB =
ifdef USE_PGXS
PG_CONFIG = pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)
else
subdir = contrib/test
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
include $(top_srcdir)/contrib/contrib-global.mk
endif
修改之后:
# contrib/test/Makefile
MODULE_big = test
OBJS = test.o
PG_CPPFLAGS = -I$(libpq_srcdir)
SHLIB_LINK = $(libpq)
SHLIB_PREREQS = submake-libpq
# the db name is hard-coded in the tests
EXTENSION = test
DATA = test--1.0.sql
ifdef USE_PGXS
PG_CONFIG = pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)
else
subdir = contrib/test
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
include $(top_srcdir)/contrib/contrib-global.mk
endif
待更>>>>>
MODULES 代表要创建的动态库列表,不要包含动态库后缀:例如:MODULES = file_fdw 就会成成 file_fdw.so文件。(见:extension/file_fdw)
MODULE_big 根据OBJS 里面的.o 文件生成的动态库。
SHLIB_LINK MODULE_big所需要的依赖库
PROGRAM 根据OBJS 里面的.o文件生成的可执行文件。
PG_LIBS PROGRAM所需要的依赖库
EXTENSION 扩展的名字(必须要有一个与改名字相同的控制文件(control))
REGRESS 回归测试列表(没有后缀)
REGRESS_OPTS 回归测试额外的配置
EXTRA_CLEAN ‘make clean’ 额外要删除的对象,一般为你插件生成的对象
PG_CPPFLAGS 编译参数,该参数为编译程序的时候用相当于CPPFLAGS,如:添加头文件 -I *.h
PGFILEDESC 描述文件
参考:https://blog.csdn.net/akakakak250/article/details/78418203