Skip to content

Instantly share code, notes, and snippets.

View LdDl's full-sized avatar
🤡
love neural networks

Dimitrii Lopanov LdDl

🤡
love neural networks
View GitHub Profile
@LdDl
LdDl / pg_upgrade_postgis.md
Last active January 31, 2024 13:50
Postges pg_upgrade workaround

My case

Current environment

  • Ubuntu 18.04
  • PostgreSQL 13.1
  • PostGIS 3.x.x + obsolete SFCGAL(somehow it was installed with PostGIS)

Target

  • PostgreSQL 14.x
  • Postgis 3.x.x
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file has been truncated, but you can view the full file.
{"type": "FeatureCollection", "features": [{"id": 7, "type": "Feature", "geometry": {"type": "MultiPolygon", "coordinates": [[[[37.874237, 55.820153], [37.874247, 55.820153], [37.874317, 55.820157], [37.874392, 55.820164], [37.874518, 55.820182], [37.875248, 55.820311], [37.875322, 55.820323], [37.87598, 55.820432], [37.876335, 55.820484], [37.876639, 55.820528], [37.877237, 55.820616], [37.878385, 55.820802], [37.878693, 55.820491], [37.879053, 55.820162], [37.879402, 55.819943], [37.879495, 55.819892], [37.879593, 55.819849], [37.879645, 55.819833], [37.88003, 55.819732], [37.880041, 55.81973], [37.880051, 55.819728], [37.880097, 55.81972], [37.880373, 55.819682], [37.880463, 55.819677], [37.880532, 55.819676], [37.880549, 55.819676], [37.880566, 55.819677], [37.880685, 55.819685], [37.881105, 55.819735], [37.881259, 55.81976], [37.881277, 55.819763], [37.881295, 55.819766], [37.882102, 55.819943], [37.882305, 55.819988], [37.882627, 55.820071], [37.882774, 55.820118], [37.882914, 55.820171], [37.883376, 55