Once again I find myself refining Postgres installation on remote server. I encountered weird problem where apt-get update was failing on newly booted Ubuntu 24. The cause for this problem turned out be the fact that I am rsync-ing files from local machine into remote server /tmp folder. This action changes the permissions of /tmp folder and causes all kinds of problem when installing packages.
Once I discovered this I was able to simplify my Postgres initialization script. I have my cluster up and running on remote machine. The GADM geopackage is also there waiting to be imported into the database. All that’s left now is to install GDAL and it’s dependencies, run simple ogr2ogr ingestion command and find out how to deploy go server.
We are getting there…