timescaledb-docker: Using docker timescale/timescaledb image, 'CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;' fails as it is not preloaded
Seems prebuilt images are misconfigured, trying to create the timescaledb extension fails because the premade docker images do not have the library preloaded in their config.
Error: FATAL: extension "timescaledb" must be preloaded
Hint: Please preload the timescaledb library via shared_preload_libraries.
This can be done by editing the config file at: /var/lib/postgresql/data/pgdata/postgresql.conf
and adding 'timescaledb' to the list in the shared_preload_libraries config.
# Modify postgresql.conf:
shared_preload_libraries = 'timescaledb'
Another way to do this, if not preloading other libraries, is with the command:
echo "shared_preload_libraries = 'timescaledb'" >> /var/lib/postgresql/data/pgdata/postgresql.conf
(Will require a database restart.)
If you REALLY know what you are doing and would like to load the library without preloading, you can disable this check with:
SET timescaledb.allow_install_without_preload = 'on';
SQLState: XX000
ErrorCode: 0
Error: An I/O error occurred while sending to the backend.
SQLState: 08006
ErrorCode: 0
About this issue
- Original URL
- State: closed
- Created 7 years ago
- Comments: 31 (10 by maintainers)
I’m totally new to TimescaleDB but trying to run the Docker version seems to end the same way as described above:
Safe to ignore, but we could probably improve it. I created an issue: https://github.com/timescale/timescaledb-docker/issues/170
so the problem is
What could it possibly be?
No worries, hopefully that works for @DanielJoyce too. We’ll work on documenting or improving that flow