How to add timescale extenstion to postgres?

TimescaleDB and PostgreSQL
1

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.

2

Hi @Ravi_sankar, probably something is wrong with your installation.

Would you mind sharing more details of how the extension was installed it? What is the operational OS and package version?

3

@Ravi_sankar you need to add via custom Docker File.
I have created an image over bitnami one with timescale db.
https://hub.docker.com/r/ayushpgupta/postgresql-timescaledb