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

[SoumitraBhandary]

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]

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 --<PG_VERSION>=<PATH TO pg_config> 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