知道了. ALTER EXTENSION timescaledb UPDATE;已经关闭-但是必须在您连接的数据库上执行，而不是在登录psql之后立即全局执行.并且建议还传递-X参数以禁用读取启动文件(〜/.psqlrc).

Got it. ALTER EXTENSION timescaledb UPDATE; was close - but this has to be executed on a database that you are connected to, not globally right after logging on to psql. And it's recommended to also pass the -X argument to disable reading the startup file (~/.psqlrc).

1. psql -X -U postgres -h localhost -W
2. \c your-timescale-extended-database-name
3. ALTER EXTENSION timescaledb UPDATE;
4. \dx

1. psql -X -U postgres -h localhost -W
2. \c your-timescale-extended-database-name
3. ALTER EXTENSION timescaledb UPDATE;
4. \dx

输出:

                                    List of installed extensions
    Name     | Version |   Schema   |                            Description
-------------+---------+------------+-------------------------------------------------------------------
plpgsql     | 1.0     | pg_catalog | PL/pgSQL procedural language
timescaledb | 0.9.1   | public     | Enables scalable inserts and complex queries for time-series data
(2 rows)

1. \q退出psql

1. \q to quit psql