added timescale to postgres and getting errors

[william-cl]

our environment 6.4 with postgresql 14 will not start now due to the below as an example. But there are over a thousand duplicates.

4 [Z3008] query failed due to primary key constraint: [0] PGRES_FATAL_ERROR:ERROR: duplicate key value violates unique constraint "4056_2343_history_pkey"
DETAIL: Key (itemid, clock, ns)=(138435, 1735227195, 920212859) already exists.

any and all help is greatly appreciated.

[Blevar]

This looks like duplicate keys are trying to use primary key - which is constrained in your db. Backup your db and then try identifying and removing duplicated items.