postgresql - How can you use the TimescaleDB extension with …
Jul 7, 2025 · Because timescaledb isn't a trusted extension, only members of "azure_pg_admin" are allowed to use COMMENT ON EXTENSION timescaledb Again, I am using the server …
postgresql - TimescaleDB in Container - Stack Overflow
Jun 24, 2020 · I need help to write Dockerfile to create TimescaleDB in a container. I found this instruction for creating a container: docker run -d --name timescaledb -p 5432:5432 -e …
timescaledb data persistance in a docker container
May 11, 2023 · I can run a timescaledb database using the Docker compose script: version: "3.9" services: timescaledb: image: timescale/timescaledb:latest-pg12 restart: …
TimescaleDB installation on postgres 14 - Stack Overflow
Jul 9, 2025 · I'm struggling to properly install TimescaleDB on my existing postgres 14 database. On my other machine I have postgres 16 and I installed it flawlessly, everything worked from …
What is space partitioning and dimensions in TimesclaleDB
May 2, 2020 · A dimension in TimescaleDB is associated with a column. Each hypertable requires to define at least a time dimension, which is a time column for the time series. Then a …
postgresql - How to create TimescaleDB Hypertable with time ...
Feb 3, 2021 · TimescaleDB also enforces uniqueness in each chunk individually. Maintaining uniqueness across chunks can affect ingesting performance dramatically. The most common …
TimescaleDB - get retention policy and chunk_time_interval for a …
Mar 4, 2022 · in TimescaleDB, how can I retrieve the length of both intervals (chunk_time_interval and retention policy interval) using a select statement, providing the table name?
postgresql - FATAL: extension "timescaledb" must be preloaded …
Jul 19, 2021 · FATAL: extension "timescaledb" must be preloaded HINT: Please preload the timescaledb library via shared_preload_libraries. The thing is that I've added timescaledb to …
postgresql - TimescaleDb: Can someone explain the concept of ...
May 7, 2020 · I'm learning timescaledb and it's concepts. But I'm unable to grasp Hypertables and it's purpose. Can someone explain this?
timescaledb - Are Primary Keys Recommended on a Timescale …
Nov 9, 2023 · (TimescaleDB engineer here). This first line of this answer is incorrect. Primary keys ARE supported - they just have to be composite keys which include the timestamp.