timescaledb - 在窗口中的 postgres db 中添加 Timescaledb 扩展找不到 timescaledb.control 错误

Question

在 Windows 中通过以下命令在 postgresql db 中添加 timescaledb 扩展。

命令：CREATE EXTENSION IF NOT EXISTS timescaledb;

错误：无法打开扩展控制文件“/usr/share/postgresql/9.5/extension/timescaledb.control”：没有这样的文件或目录

尝试再次为 postgresql 和 timescale db 进行设置，但没有发生。可以在路径“C:\Program Files\PostgreSQL\10\share\extension\timescaledb.control”处看到文件，以任何方式设置错误路径。

pg_config 的输出：

BINDIR = C:/PROGRA~1/POSTGR~1/10/bin
DOCDIR = C:/PROGRA~1/POSTGR~1/10/doc
HTMLDIR = C:/PROGRA~1/POSTGR~1/10/doc
INCLUDEDIR = C:/PROGRA~1/POSTGR~1/10/include
PKGINCLUDEDIR = C:/PROGRA~1/POSTGR~1/10/include
INCLUDEDIR-SERVER = C:/PROGRA~1/POSTGR~1/10/include/server
LIBDIR = C:/PROGRA~1/POSTGR~1/10/lib
PKGLIBDIR = C:/PROGRA~1/POSTGR~1/10/lib
LOCALEDIR = C:/PROGRA~1/POSTGR~1/10/share/locale
MANDIR = C:/Program Files/PostgreSQL/10/man
SHAREDIR = C:/PROGRA~1/POSTGR~1/10/share
SYSCONFDIR = C:/Program Files/PostgreSQL/10/etc
PGXS = C:/Program Files/PostgreSQL/10/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = --enable-thread-safety --enable-nls --with-ldap --with-openssl --with-ossp-uuid --with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python
CC = not recorded
CPPFLAGS = not recorded
CFLAGS = not recorded
CFLAGS_SL = not recorded
LDFLAGS = not recorded
LDFLAGS_EX = not recorded
LDFLAGS_SL = not recorded
LIBS = not recorded
VERSION = PostgreSQL 10.11

标签： timescaledb