search

tembo-io / pg_timeseries

Simple and focused time-series tables for PostgreSQL, from Tembo
PostgreSQL License
328 stars 5 forks source link

Missing `pg_ivm` extension in v0.1.6/latest Docker tag #33

Closed kaysersoze closed 1 month ago

kaysersoze commented 1 month ago

When creating a new pg_timeseries project using the latest tag, and executing the CREATE EXTENSION timeseries CASCADE; instruction, I get the following Postgres error:

NOTICE:  installing required extension "columnar"
NOTICE:  installing required extension "pg_cron"
NOTICE:  installing required extension "pg_ivm"

Query 1 ERROR at Line 1: : ERROR:  extension "pg_ivm" is not available
DETAIL:  Could not open extension control file "/usr/share/postgresql/16/extension/pg_ivm.control": No such file or directory.
HINT:  The extension must first be installed on the system where PostgreSQL is running.

However, if I revert to the v0.1.5 Docker tag, it works correctly:

NOTICE:  installing required extension "columnar"
NOTICE:  installing required extension "pg_cron"
NOTICE:  installing required extension "pg_partman"

Query 1 OK: CREATE EXTENSION
ChuckHend commented 1 month ago

Thanks for raising the issue @kaysersoze . We added a dependency on pg_ivm (Tembo's fork of it) in the latest release. This was an oversight on our part that it didnt make it into the image.

We'll get the build updated and a new image published.

ChuckHend commented 1 month ago

@kaysersoze thanks again for letting us know about the issue. We rebuilt the latest and v0.1.6 tags