Timescaledb extension not enabled intermittently

Question

I am using timescale/timescaledb:latest-pg11 docker image to run timescale in my local. While testing, I tried running it multiple times. Once while trying to creat a hyper_table, I got the below error,

function create_hypertable(unknown, unknown, migrate_data => boolean) does not exist

As troubleshooting, I got this answer, which suggested checking the pg extensions. So on the run when I got error, I didn't have timescaledb in the result of select * from pg_extension;. Whereas, in successful cases, I had the timescaledb extension.

I am unable to reproduce the error case again. But any idea why the issue happened randomly?

PS: I used the same docker run command to run the container everytime.

I have the same issue, but do not know why and how this happening. — Roger Dwan, Jan 10 '20 at 07:54
I am not sure 'why'. But the linked answer solved the problem then. — Kannan Ramamoorthy, Jan 10 '20 at 12:33

score 0 · Answer 1 · answered Mar 07 '20 at 15:22

I had similar problems. I fixed it by using this docker-compose file

version: '2.1'
services:
  postgres:
    image: timescale/timescaledb-postgis
    environment:
      POSTGRES_USER: test
      POSTGRES_PASSWORD: test
      POSTGRES_DB: tutorial
    volumes:
      - ./data/postgres:/var/lib/postgresql/data
    ports:
      - "5432:5432"
    restart: always

Timescaledb extension not enabled intermittently

1 Answers1