将问题时间刻度数据库从2.2.1更新到2.3.0

Question

我正在尝试将时间刻度数据库从2.2.1更新到2.3.0

但当输入以下内容时：ALTER EXTENSION timescaldb UPDATE

我收到这个错误消息：

"ERROR:  extension "timescaledb" cannot be updated after the old version has already been loaded
HINT:  Start a new session and execute ALTER EXTENSION as the first command. Make sure to pass the "-X" flag to psql."
psql -X -U postgres -h localhost -d zabbix

---

zabbix=> dx timescaledb
timescaledb | 2.2.1   | public | Enables scalable inserts and complex queries for time-series data
(1 row)

---

zabbix=> SELECT default_version, installed_version FROM pg_available_extensions
where name = 'timescaledb';
default_version | installed_version 
2.3.0           | 2.2.1
(1 row)

这是一个复制品。我想我可能得换一种方式。

Answer 1

从shared_preload_libraries中删除timescaledb并重新启动PostgreSQL。

然后扩展没有加载，您可以升级它。

然后，再次将库添加到shared_preload_libraries，然后再次重新启动。