0

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 the start but on psql14 it was installing in the wrong schema for some reason:

I had pgivm and the create extension command was installing the extension in the pgivm schema instead of the right one (I assume it's the public). After changing it to the public schema I ran the query "SELECT proname FROM pg_proc WHERE proname ILIKE '%timescale%' LIMIT 5;" and it only shows the timescaledb_pre_restore and timescaledb_post_restore functions available.

I can't create hypertables, call pgivm.timescaledb_version, etc.

Is my DB borked?

EDIT: I've reinstalled the whole postgres server, it creates the extension automatically on the public schema but the error persists. As asked in the comments, I changed the schema by dropping the extensions and creating it adding "WITH SCHEMA public".

Improve this question
11
  • Could you share the OS version and TimescaleDB versions? Do you receive any error messages when trying to create a hypertable? And please check pg_extension: SELECT nspname, extname, extversion FROM pg_extension JOIN pg_namespace sch ON sch.oid = pg_extension.extnamespace; Commented Jul 9 at 17:09
  • Please edit the question and ad the information what exactly you did to change the extension to the public schema. Commented Jul 9 at 17:27
  • @LaurenzAlbe done Commented Jul 9 at 17:33
  • @FrankHeikens Ubunutu 22.04, timescaleDB version 2.19.3 Your query gives me the result nspname | extname | extversion ------------+-------------+------------ pg_catalog | plpgsql | 1.0 public | timescaledb | 2.19.3 I have reinstalled the whole postgres server but the error persist. Commented Jul 9 at 17:33
  • the error persists I don't see any error message Commented Jul 9 at 17:58
Related questions
1040
psql: FATAL: database "<user>" does not exist
1252
Getting error: Peer authentication failed for user "postgres", when trying to get pgsql working with rails
3
timescaledb with spring data jpa
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.