暂无图片
create extension pg_bulkload 失败
我来答
分享
暂无图片 匿名用户
create extension pg_bulkload 失败

[root@pg-soft]# rpm -ivh pg_bulkload10-client-3.1.16-1.rhel6.x86_64.rpm
warning: pg_bulkload10-client-3.1.16-1.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing... ########################################### [100%]
1:pg_bulkload10-client ########################################### [100%]

[root@ pg-soft]# rpm -ivh pg_bulkload10-3.1.16-1.rhel6.x86_64.rpm
warning: pg_bulkload10-3.1.16-1.rhel6.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY
Preparing... ########################################### [100%]
1:pg_bulkload10 ########################################### [100%]


#create extension pg_bulkload;
ERROR: could not open extension control file "/opt/pgbinary/pgsql/share/postgresql/extension/pg_bulkload.control": 没有那个文件或目录

请问如何解决??

pg  版本10

linux  centos 6.5 

我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
hehe

查找一下这个文件,pg_bulkload.control,然后放到这个路径下面/opt/pgbinary/pgsql/share/postgresql/extension/,在执行create extension pg_bulkload,看行不行

暂无图片 评论
暂无图片 有用 0
彭冲

pg服务是源码编译 插件是rpm安装 这两者不一致

试试插件源码编译下

暂无图片 评论
暂无图片 有用 0
李先生

当前pg_bulkload最新版本3.1.19支持PostgreSQL 9.6/10/11/12/13/14。
建议通过源码编译安装最新版本:

[postgres@pg1 ~]$ ll pg_bulkload-master.zip -rwxr-xr-x. 1 root root 531031 Feb 17 17:19 pg_bulkload-master.zip [postgres@pg1 ~]$ [postgres@pg1 ~]$ unzip pg_bulkload-master.zip Archive: pg_bulkload-master.zip 300d058135e482106672aecec674bee2a52d5e2e creating: pg_bulkload-master/ ...... inflating: pg_bulkload-master/util/uninstall_pg_timestamp.sql [postgres@pg1 ~]$ cd pg_bulkload-master/ [postgres@pg1 pg_bulkload-master]$ make Makefile:33: warning: overriding recipe for target `check' ...... make[1]: Leaving directory `/home/postgres/pg_bulkload-master/util' [postgres@pg1 pg_bulkload-master]$ [postgres@pg1 pg_bulkload-master]$ make install Makefile:33: warning: overriding recipe for target `check' ...... make[1]: Leaving directory `/home/postgres/pg_bulkload-master/util' [postgres@pg1 pg_bulkload-master]$ [postgres@pg1 pg_bulkload-master]$ [postgres@pg1 pg_bulkload-master]$ psql psql (14.1) Type "help" for help. postgres=# create extension pg_bulkload ; CREATE EXTENSION postgres=#
暂无图片 评论
暂无图片 有用 0
严少安
暂无图片

提供的两个版本信息都对,从RPM包名也可以看出是PG10为el6编译的包。
找到了这两个的RPM:
https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/
pg_bulkload10-3.1.16-1.rhel6.x86_64.rpm
pg_bulkload10-client-3.1.16-1.rhel6.x86_64.rpm
解压后,可以发现,pg_bulkload10的安装路径为:/usr/pgsql-10/share/extension/
即,直接安装两个PRM后,文件pg_bulkload.control将位于:/usr/pgsql-10/share/extension/pg_bulkload.control
解决办法:可以将RPM解压,文件复制到PG实际的安装路径下:/opt/pgbinary/pgsql/share/postgresql/extension

暂无图片 评论
暂无图片 有用 0
nanjing_2013

[postgres@test_dan pg_bulkload-VERSION3_1_16]$ make
make[1]: Entering directory `/soft/pg-soft/pg_bulkload-VERSION3_1_16/bin'
gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -g -O2 -DMAP_HUGETLB=0x40000 pg_bulkload.o recovery.o pgut/pgut.o pgut/pgut-fe.o pgut/pgut-list.o -L/opt/pgbinary/pgsql/lib -L/opt/local/Current/lib -Wl,--as-needed -Wl,-rpath,'/opt/pgbinary/pgsql/lib',--enable-new-dtags -Wl,--build-id -L/opt/pgbinary/pgsql/lib -lpq -lpgcommon -lpgport -lpam -lssl -lcrypto -lgssapi_krb5 -lz -ledit -lrt -lcrypt -ldl -lm -o pg_bulkload
/usr/bin/ld: cannot find -lpam
collect2: ld 返回 1
make[1]: *** [pg_bulkload] 错误 1
make[1]: Leaving directory `/soft/pg-soft/pg_bulkload-VERSION3_1_16/bin'
make: *** [all] 错误 2
[postgres@test_dan pg_bulkload-VERSION3_1_16]$ cd ../


我是源码编译没通过,才下载的rpm包,请问这个错误是啥意思

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏