Dealing with topology data corruption on upgrade to 3.6.0

Sandro Santilli strk at kbt.io
Wed Oct 15 07:36:32 PDT 2025


The 3.6.0 release introduced a bug that results in data corruption:
https://trac.osgeo.org/postgis/ticket/5983

This means that whoever upgraded to 3.6.0 while having topology data is
now in a data-corruption state and any update to their data will
make the situation worse beacuse they would end up with a mix of valid
and invalid rows.

It would be nice if the proponent of the change which introduced the
problem (in Cc) would partecipate in the effort of providing a fix for it,
and I hope we won't repeat the mistake of accepting contributions before
all issues raised during review are addressed [1]

[1] https://gitea.osgeo.org/postgis/postgis/pulls/242#issuecomment-13471

I think this should be announced to the users because as the damage could
be mitigated by restoring a backup into a 3.5.x version until we find
a solution.


--strk; 

  Libre GIS consultant/developer 🎺
  https://strk.kbt.io/services.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 659 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20251015/74291a32/attachment.sig>


More information about the postgis-devel mailing list