install timescale on postgresql

[mcncyo]

I am trying to get timescale working on postgresql. I installed both of them. but When I tried to run

echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix

i get this error

extension "timescaledb" has no installation script nor update path for version "2.14.2"

can anyone tell me what i am doing wrong?


this is how i installed postgresql and timescaledb on a clean debain computer

Nala install gnupg2 wget
sudo sh -c 'echo "deb https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key

sudo nala update







sudo nala install postgresql-14




systemctl enable postgresql –now




sudo su – postgres




psql




\q




\exit




cd /etc/postgresql/14/main




pico postgresql.conf




max connection to 150

systemctl restart postgresql




sudo -u postgres createuser –pwprompt zabbix




type in a password for zabbix user on postsql







sudo -u postgres createdb -O zabbix zabbix




wget https://repo.zabbix.com/zabbix/6.4/d...bian12_all.deb







dpkg -i zabbix-release_6.4-1+debian12_all.deb










nala install zabbix-sql-scripts







adduser zabbix

usermod -aG sudo zabbix

cd /etc/postgresql/14/main

pico postgresql.conf




change to

listen_addresses = '*'







pico pg_hba.conf




change

host all all 127.0.0.1/32







host all all 0.0.0.0/0










install timescale db as follows







echo "deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list







wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/timescaledb.gpg







nala update







sudo nala install timescaledb-2-2.13.1-postgresql-14=2.13.1~debian12




timescaledb-tune




cd /etc/postgresql/14/main




pico postgresql.conf

change

max_connections = 150







systemctl restart postgresql

[cyber]

Somekind of version mismatch... you install version 2.13.1 (sudo nala install timescaledb-2-2.13.1-postgresql-14=2.13.1~debian12) but during extension adding it complains about 2.14.2..? Why do you even install older version if 2.14.2 is available?