Unable to restore pg_dump with compressed db

TimescaleDB and PostgreSQL
1

Hello,

Using 2.13.0, I am unable to restore a pg_dump of my db
It fails at the first chunk with

ERROR:  null value in column "creation_time" of relation "chunk" violates not-null constraint

It was definitely working before (i.e. my backup/restore process) so not sure if this is correlated to activating compression on one table or using a more recent version of timescaledb

Do you have any idea ?

Thanks!
Mat

2

Solved and replying to myself if anyone get the same issue
Source was using 2.12.0 and Target 2.13.0 … Upgrading the source and dumping again solved it

1 Like
3

Yay! thanks for sharing Mats!