archives / 2022 /


Postgis in multiple schema

Posted Wed 05 Oct 2022 10:30:19 AM CEST Florian Lohoff in

Restoring the very same dump into multiple schemas is not that easy when using postgis. Typically a pg_dump contains public.geometry when creating the tables which is not reachable as postgis will be in a different schema at least on the second import.

First create a different schema for the postgis extension

create schema postgis;
create extension postgis with schema postgis;

Then set the search path for non schema qualified postgis functions to be found:

alter database joineddb SET search_path TO public,postgis;

Then feed your psql dumps into psql using sed. This import will end up in the public schema:

zcat "dump-with-postgis-new.sql.gz"  \
    | sed -e 's/public.geometry/postgis.geometry/ig'\
    | psql -f - joineddb

Then connect to the database and rename schema:

alter schema public rename to new;
create schema public;

And import the second file:

zcat "dump-with-postgis-old.sql.gz"  \
    | sed -e 's/public.geometry/postgis.geometry/ig'\
    | psql -f - joineddb

Now you have both dumps in the database for comparison.

ArubaOS AP Firmware

Posted Fri 07 Oct 2022 09:32:15 AM CEST Florian Lohoff in

Aruba published a set of CVEs concerning the AP Firmware, but the issue is that when you dont have a login, and your APs dont have direct internet access or the internet access is crippled you are dead in the water.

But when looking at some debug output you'll find the original URLs the APs would try to download the firmware:

Like this. The last part of the URI can be determined from the Aruba Website and is platform and version dependent:



Posted Fri 14 Oct 2022 06:07:22 PM CEST Florian Lohoff in

Das Katzentier kommt langsam in die Winterruhe und döst auf der Armlehne vom Sessel.

Motorradclub on the road

Posted Fri 14 Oct 2022 06:08:34 PM CEST Florian Lohoff in

Der MC Hardrock Lohoff unterwegs um die nicht beräderten am Bahnhof einzusammeln.

Rosemarie Nitribitt

Posted Mon 24 Oct 2022 06:44:03 PM CEST Florian Lohoff in

Wenn man schon über den Nordfriedhof in Düsseldorf spaziert dann auch an das Grab von Rosemarie Nitribitt.


Posted Mon 24 Oct 2022 06:45:08 PM CEST Florian Lohoff in

Quittengelee mit Vanille. Sehr lecker nur ein bisschen flüssig vielleicht.

josm plbuildings for Northrhine-Westfalia

Posted Thu 27 Oct 2022 09:44:14 AM CEST Florian Lohoff in

For a long time building imports in Northrhine-Westfalia or NRW was a hassle. The only source would be a WMS server and some people wrote software to convert the WMS tiles back to some useful vector informations and merge into the josm dataset. This solution was pretty fragile and my impression is that its basically unmaintained, although it still works for me.

For a long time i was looking for a solution to use something like generic WFS in JOSM with a rule based merging of tags and or geometries (Which geometries to use nodes from, snap distance etc). Nothing like this popped up in the last 10 years.

So i had a look yesterday and found the plbuildings plugin which just needs the right server component to serve OSM XML files.

So i quickly hacked a server component to server the NRW Open Data Shape dataset.

When you install the plbuildings plugin into josm, and change the URL to:


You will be able to import building outlines from the Hausumringe NRW dataset. I am not that happy with the amount of nodes this dataset contains, or the usability with the plbuildings plugin, but its a start.

Also this will most like break horribly if you have real multipolygon buildings e.g. with a hole in the middle. This is not yet implemented at least on the server side as it would require to serve back a relation. I have no idea whether the plbuildings plugin supports this.

3 Messen zusammen

Posted Sun 30 Oct 2022 04:10:56 PM CET Florian Lohoff in

Es war lustig. Aber nicht so ausgedehnt wie erwartet. Auf der iEna gefühlt 50% Asiaten, und 30% China.

Sehr spannend das die Mint Gruppe eines Gymnasiums gegenüber dem Marken und Patentamt der Türkei steht. Lustige Kombination.

Automatik U-Bahn

Posted Sun 30 Oct 2022 04:12:31 PM CET Florian Lohoff in

Sehr spannend. Eine Zugführerlose U-Bahn in Nürnberg. Man kann ganz vorne sitzen und in den Tunnel blicken.


Posted Sun 30 Oct 2022 04:14:05 PM CET Florian Lohoff in

Ich würde sagen Deutschland ist im Arsch. China voll mit Ideen und Prototypen. Deutschland hat einen Schweinezaun und präsentiert die ausgestopfte Sau.


Posted Sun 30 Oct 2022 04:42:06 PM CET Florian Lohoff in

Statt schloss Pleuel und Kolben. Heiss brennende liebe würde ich sagen.


Posted Sun 30 Oct 2022 04:43:30 PM CET Florian Lohoff in

Ich konnte nicht dran vorbei ohne einen Cola Canabis Lutscher zu kaufen.

Wenigstens den Automaten ein wenig Finanzieren.