Antoon Huiskens

Results 6 comments of Antoon Huiskens

From a minimalist point of view... being able to send the query logs to any syslog server would be straightforward I suppose. With the query log in syslog there will...

Below snippet is my from my packer workaround: ``` provisioner "file" { destination = "/etc/apt/sources.list.d/bullseye-backports.list" content =

Here's an example postgres/timescaledb query for grafana. Thought I'd be verbose and comment on the value for me. my environment looks like this: * postgresql 15.6 * timescaledb 2.14.2+extensions *...

If you want to use annotations, the state_timeline() hyperfunctions are really fun. ```sql SELECT start_time, end_time, 'home assistant status' as title, state as text FROM state_timeline( ( SELECT state_agg(time, state)...

got caught out by this one too. Though infact at first glance it seems unrelated to compression (it's disabled).

Ok. Just had another go at upgrading: I'm getting this: ``` Error during connection setup: (psycopg2.errors.UndefinedObject) constraint "ltss_pkey" of relation "ltss" does not exist [SQL: ALTER TABLE ltss DROP CONSTRAINT...