search

imusmanmalik / cloudnative-pg-timescaledb-postgis-containers

Operand images for CloudNativePG containing PostgreSQL with TimescaleDB and PostGIS
Apache License 2.0
33 stars 13 forks source link

Add Timescale Tagging #20

Closed bkief closed 7 months ago

bkief commented 8 months ago

Consider adding the Timescale version to the image tag name. I am finding out (the hard way) that restoring a backup from running an image with and older version of Timescale is a challenge. Ideally the backup should restore to a server with the same Timescale version.

imusmanmalik commented 7 months ago

@bkief do you have any suggestions for this? at the moment TimescaleDB is 2.x

https://github.com/imusmanmalik/cloudnative-pg-timescaledb-postgis-containers/blob/main/TimescaleDB-PostGIS/16/Dockerfile#L28

bkief commented 7 months ago

I've found that simply using the specific build number in the image tag is enough to hold the timescale version steady. eg 16-3.4-31

The root issue is that the timescale minor versions aren't compatible (2.11 vs 2.13) and pg_dump does not include the timescale version number. So when trying to restore a pg_dump database export, I was left trying to figure out what the original timescale version was, which was a problem when just using the tag 15-3.4 I think this can be closed