Ad Widget

Collapse

Migrate TImescale to new host

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tristis Oris
    Member
    • Sep 2015
    • 66

    #1

    Migrate TImescale to new host

    zabbix 7.x, can't migrate database according to https://docs.timescale.com/migrate/l...p-and-restore/

    Code:
    COPY 0
    COPY 0
    COPY 0
    psql:/opt/dump.sql:14105578: ERROR: function base36_decode(text) does not exist
    LINE 1: CAST(base36_decode(substring(cuid FROM 2 FOR 8))/1000 AS int...
    ^
    HINT: No function matches the given name and argument types. You might need to add explicit type casts.
    QUERY: CAST(base36_decode(substring(cuid FROM 2 FOR 8))/1000 AS integer)
    CONTEXT: PL/pgSQL function public.cuid_timestamp(character varying) line 3 at RETURN
    COPY _hyper_15_2457_chunk, line 1: "clz0iblk87jezwciyuwk7tsbb \N System 1721865602 1 15 737456 \N FS [/boot]: Space: Used clz0ibllh7jh7..."
    psql:/opt/dump.sql:14105578: STATEMENT: COPY "_timescaledb_internal"."_hyper_15_2457_chunk" ("auditid", "userid", "username", "clock", "ip", "action", "resourcetype", "resourceid", "resource_cuid", "resourcename", "recordsetid", "details") FROM stdin;
    Last edited by Tristis Oris; 30-07-2024, 11:40.
Working...