Postgresapp: Add timescaledb extension

[mashaalmemon]

Would like to request that the TimescaleDb extension be added to the distribution?

Azure will be adding this extension in their managed Postgres environment as of this month as can be seen here. We would love to have the extension available in our local development environments, which today is Postgres.app.

[jakob]

How difficult is building Timescale yourself with Postgres.app? Do the instructions from their docs work with Postgres.app? https://docs.timescale.com/v1.2/getting-started/installation/macos/installation-source

I understand that it would be nice to have out-of-the-box support like with PostGIS, but I really don't know how popular TimescaleDB is. Building Postgres.app is a lot of work already, so I'm not all too eager to add even more things...

[mashaalmemon]

Hi Jacob,

I just went through the process and it isn't very difficult at all. I had to do a bit of digging around in order to figure out how to have the "pg_config" of the particular server version be the one that TimescaleDB would use, but once I figured that out it was pretty smooth sailing.

The instructions for timescale work except:

• You need the local "pg_config" from the postgres.app version of Postgres to be the default.
• "./bootstrap" will not work if you don't have "openssl" installed, but you can ignore that with a switch like so: "./bootstrap -DUSE_OPENSSL=0"
• Other than this the instructions seem to work well and extension was installed from source without a hitch.

Re out of the box support, understand how that can add overhead. Perhaps in lieu of this, it makes sense to add some info into the documentation on how to install extensions?

[slashdotdash]

I've written up a step-by-step guide to installing TimescaleDB with Postgres.app following the "install from source" instructions.