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 / check_gitlab.sh
Created March 26, 2025 11:48
Bash script to scan Gitlab repositories to check if there are any branches, containers, packages or variables
#!/bin/bash
GITLAB_URL="https://gitlab.my.site.com"
GROUP_PATH="my-group" # Your group path
TOKEN="" # Token with read_api + read_registry + read_repository
PER_PAGE=100 # Max repos per page
OUTPUT_FILE="repo_analysis.csv"
echo "Generating repository analysis report..."
@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