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