How to uninstall timescaledb (installed from source)

TimescaleDB and PostgreSQL Installation, Configuration, and Errors
1

In brief:
I need to remove TimescaleDB in order to install a different version. Since there’s no ‘make uninstall’ script, I’m seeking guidance on the proper way to uninstall it cleanly.

TimescaleDB version: 2.13.1
PostgreSQL version: 13
OS: Debian 11
Platform: WSL
Install method: [Source] +https://github.com/timescale/timescaledb
Environment: Test

What directories have to be deleted?
I read this tutorial: +https://docs.timescale.com/self-hosted/latest/uninstall/uninstall-timescaledb/ but points >2 do not me help me.

2

Hi Malte, that’s a great point. I think we don’t have it. It would be a great suggestion to make it part of the official scripts. Our scripts are always overriding it.

Feel free to suggest it as a feature. You need to reverse the installation and it involves undo this steps that is timescaledb_move.sh. You can get it by getting the content with: cat $(which timescaledb_move.sh)

In my case it comes from my homebrew:

/usr/bin/install -c -m 755 $(find /usr/local/Cellar/timescaledb/2.13.1/lib -name timescaledb*.dylib) /usr/local/opt/postgresql@16/lib/postgresql/
/usr/bin/install -c -m 644 /usr/local/Cellar/timescaledb/2.13.1/share/timescaledb/* /usr/local/opt/postgresql@16/share/postgresql@16/extension/

Note that *.dylib is for pg16 but for pg15 I guess the old extension files were .so.
So, if I want to remove I need to build a revert script like:

rm /usr/local/opt/postgresql@16/lib/postgresql/$(find /usr/local/Cellar/timescaledb/2.13.1/lib -name timescaledb*.dylib)

I hope it helps, and I’d encourage you to bring it as a request in the official repo. Probably it would really worth to add it officially.