2

I am using PostgreSQL 14. I have finally managed to build the timescaledb-toolkit for it (based on the alpine docker image) and now I get the control file, the library, everything. So, I execute

CREATE EXTENSION timescaledb_toolkit;

and there is no error, but the moment I try to use any function defined on the extension I get

db=# SELECT time_bucket('5m'::interval, time) AS five_min, delta(counter_agg(time, energy_t1_in)) AS net_in FROM electricity GROUP BY five_min;
ERROR:  function counter_agg(timestamp without time zone, numeric) does not exist
LINE 1: ...e_bucket('5m'::interval, time) AS five_min, delta(counter_ag...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

Following this answer I can see that no methods are listed for the extension, which makes me think that somehow the extension is installed but not really "registered" (?). How can I fix this?

chronos
  • 325
  • 6
  • 12
  • Connect with `psql` and verify with `\dx+ timescaledb_toolkit`. – Laurenz Albe Feb 19 '22 at 15:31
  • Is this a `search_path` issue? Where the extension installed it's functions in a schema that is not currently in your `search_path`. On `psql` do `\dn` for the schemas and `show search_path` for the current path. Add as update to your question. – Adrian Klaver Feb 19 '22 at 16:45
  • Did this issue get resolved? We likewise wish to run the Toolkit on the Alpine-based Docker image, but have not even gotten as far as you. – Arturo Aguilar Apr 18 '22 at 18:02
  • @ArturoAguilar Nope, I did not get through. I switched to the HA docker container and did not give it any more thought :-/ – chronos Apr 20 '22 at 16:32

0 Answers0