postgresql 初始化 initdb 出现No such file or directory

1.initdb出现

 FATAL:  could not open extension control file "/opt/HighGo/Develop/share/postgresql/extension/file_fdw.control": No such file or directory.
如下图.
me@me:/opt/HighGo/Develop/bin$ ./initdb -D ../data -W
The files belonging to this database system will be owned by user "me".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
creating directory ../data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in ../data/base/1 ... ok
initializing pg_authid ... ok
Enter new systemuser password: 
Enter it again: 
Enter syssao password: 
Enter it again: 
Enter syssso password: 
Enter it again: 
setting dba password ... ok
initializing dependencies ... ok
creating system views ... FATAL:  could not open extension control file "/opt/HighGo/Develop/share/postgresql/extension/file_fdw.control": No such file or directory
STATEMENT:  /*
	 * PostgreSQL System Views
	 *
	 * Copyright (c) 1996-2012, PostgreSQL Global Development Group
	 *
	 * src/backend/catalog/system_views.sql

原因是file_fdw.control插件没有安装.进入源代码目录下的contrib目录下.找到file_fdw文件进入其中,编译安装,

make
make install

同理出现:

creating system views ... FATAL: 

 could not open extension control file "/opt/HighGo/Develop/share/postgresql/extension/dblink.control": No such file or directory.


在contrib目录下进入到dblink文件中,make,make install

所以如果出现一些其他的hstore.control 等.相应的安装上.

done

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值