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.

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:

http://common.cloud.hpe.com/ccssvc/ccs-system-firmware-registry/IAP/ArubaInstant_Gemini_8.11.0.0_85179

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

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

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

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

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:

plbuildings.server_url=https://osm.zz.de/plbuildingsnrw/v1/

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.

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.

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

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

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

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

Wenigstens den Automaten ein wenig Finanzieren.