# TimescaleDB Update

[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/g71pSE3C7p2eTy2b-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/g71pSE3C7p2eTy2b-image.png)

<div id="bkmrk-ajouter-le-proxy-ave">Ajouter le proxy avec la commande export</div><div id="bkmrk--1">  
</div><div id="bkmrk-yum-update"><span style="color: rgb(230, 126, 35);">Yum update</span></div><div id="bkmrk--2">  
</div>[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/Qliyo0BWZVufJVCr-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/Qliyo0BWZVufJVCr-image.png)

<div id="bkmrk--4">  
</div><div id="bkmrk-installation-%C3%A0-la-ma">Installation à la mano:</div><div id="bkmrk-yum-update-timescale"><span style="color: rgb(230, 126, 35);">yum update timescaledb-2-postgresql-12</span></div><div id="bkmrk-systemctl-restart-po"><span style="color: rgb(230, 126, 35);">systemctl restart postgresql-12</span></div><div id="bkmrk-timescaledb-tune---p"><span style="color: rgb(230, 126, 35);">timescaledb-tune --pg-config=/usr/pgsql-12/bin/pg\_config</span></div><div id="bkmrk--5">  
</div>[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/rafkb4UY48PIiPWn-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/rafkb4UY48PIiPWn-image.png)

<div id="bkmrk-sudo--u-%22user%22--i-ps">sudo -u "user" -i psql</div><div id="bkmrk-%5Cc-database">\c database</div><div id="bkmrk-%5Cdx">\dx</div><div id="bkmrk-alter-extension-time">ALTER EXTENSION timescaledb UPDATE;</div><div id="bkmrk--7">  
</div>[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/hjKt49PSJWQJELji-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/hjKt49PSJWQJELji-image.png)\\q

<div id="bkmrk--8"></div><div id="bkmrk--9">  
</div><div id="bkmrk-infos-suppl%C3%A9mentaire">Infos supplémentaire:</div><div id="bkmrk-je-vois-bien-la-dern">Je vois bien la dernière version de timescaledb dans pg_available_extensions, mais la version installée sur la BDD reste toujours la 2.8.1.</div><div id="bkmrk--10">  
</div>[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/i5dBr8EGJF9tI7kI-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/i5dBr8EGJF9tI7kI-image.png)

[![image.png](https://cavallone.fr/uploads/images/gallery/2024-10/scaled-1680-/9t0fY77J4uTG7eMu-image.png)](https://cavallone.fr/uploads/images/gallery/2024-10/9t0fY77J4uTG7eMu-image.png)

<div id="bkmrk-il-faudrait-donc-met">Il faudrait donc mettre à jour la version de timescaledb sur la BDD MASS.</div><div id="bkmrk-exemple-%3A">Exemple :</div><div id="bkmrk---alter-extension-ti">- <span style="color: rgb(230, 126, 35);">ALTER EXTENSION timescaledb UPDATE TO '2.11.2';</span></div><div id="bkmrk-https%3A%2F%2Fwww.postgres">https://www.postgresql.org/docs/12/sql-alterextension.html</div><div id="bkmrk---ou-si-%C3%A7a-ne-foncti">- Ou si ça ne fonctionne pas, désinstaller puis réinstaller : </div><div id="bkmrk-drop-extension-times"><span style="color: rgb(230, 126, 35);">DROP EXTENSION timescaledb CASCADE; </span></div><div id="bkmrk-create-extension-if-"><span style="color: rgb(230, 126, 35);">CREATE EXTENSION IF NOT EXISTS timescaledb;</span></div><div id="bkmrk--13"></div>