installing timescaledb for an older version of postgres

[tonypeng]

I'm trying to set up TimescaleDB with Postgres.app (https://stackoverflow.com/questions/73248119/how-do-you-install-timescaledb-on-mac-os-m1-apple-silicone-if-you-have-the-pos)

It seems when I run brew install timescaledb it installs against Postgres 17, but my Postgres.app is running Postgres 14. I tried running brew edit timescaledb and changing the dependency to postgresql@14, but that just resulted in build errors when running brew install timescaledb.

Any way to accomplish this?

[tonypeng]

got it to work by running brew edit timescaledb and replacing the formula with this older version

but still wondering how/if it's possible to install the latest version against PG14

[thbar]

FWIW, the compatibility matrix is here, which indicates that TimescaleDB 2.20.x is not compatible with Postgres 14:

https://docs.tigerdata.com/self-hosted/latest/upgrades/upgrade-pg/#plan-your-upgrade-path

[tonypeng]

at the time the issue was posted the latest version seems to have been 2.18