timescale / timescaledb-toolkit

Extension for more hyperfunctions, fully compatible with TimescaleDB and PostgreSQL 📈
https://www.timescale.com
Other
370 stars 46 forks source link

Need to install timescaleDB toolkit for timescaleDB to enable stat analysis of continuous aggregate #763

Open SoumitraBhandary opened 1 year ago

SoumitraBhandary commented 1 year ago

Discussed in https://github.com/timescale/timescaledb-toolkit/discussions/760

Originally posted by **SoumitraBhandary** June 9, 2023 I have one Postgres environemnt already running in Linux VM . I have installed timescaledb extension . But during installation I did not go for timescaleDB toolkit set up and installation steps, as it was not required. Now I need to install timescaleDB toolkit in the same environment . But I can see the steps as mentioned here : https://github.com/timescale/timescaledb-toolkit/blob/main/Readme.md sudo apt-get install make gcc pkg-config clang postgresql-server-dev-14 libssl-dev & cargo pgx init --pg14 pg_config Which requires to re init and re compile the PG BINARIES TO INSTALL THE TOOL KIT > Is there any way I can install it in an already existing Postgres which was not compiled with cargo pgx ? Please suggest.
WireBaron commented 1 year ago

It's actually just the toolkit extension that needs to be compiled with cargo pgx. Once built it works with your normal postgres installation. If you already have postgres installed, you can actually build with it by doing a: cargo pgx init --= Instead of the commands you pasted above.

That being said, if you're on one of our supported platforms you can just download the already built extension using yum or apt. See here for details: https://docs.timescale.com/self-hosted/latest/tooling/install-toolkit/#install-toolkit-on-self-hosted-timescaledb