I have installed postgres in rancher cluster through bitnami postgres chart.
Now I have executed below query to add timescale extension.
CREATE EXTENSION IF NOT EXISTS timescaledb;
I received below error. How to fix it?
ERROR: extension “timescaledb” is not available
DETAIL: Could not open extension control file “/opt/bitnami/postgresql/share/extension/timescaledb.control”: No such file or directory.
HINT: The extension must first be installed on the system where PostgreSQL is running.