vendekagon-labs / unify

An engine for automating data integration & harmonization via schema inference.
Apache License 2.0
8 stars 0 forks source link

Tighten Postgres version in local ops #44

Open benkamphaus opened 2 months ago

benkamphaus commented 2 months ago

Apparently, specifying a minor release version is not sufficient to prevent data compatibility bugs between postgres container/image versions that appear in local systems. These manifest e.g. as:

local-postgres-1        | 2024-08-12 18:02:04.032 UTC [39] WARNING:  database "unify" has a collation version mismatch

A workaround is to connect to the local system container with:

psql -h localhost -p 4335 -U unify

And run:

ALTER DATABASE unify REFRESH COLLATION VERSION;

Whenever this happens, but better to lock down to a tighter docker-compose version and not subject users to this.