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