Allow extracting the PostgreSQL database from the Nominatim stack about headway HOT 7 CLOSED

@3nprob seemed interested in doing this. Please do note though that nominatim databases require custom tuning for best performance (not currently done in headway), and a postgis extension to be installed.

from headway.

I should also mention that I don't want to start on this work until #81 or some successor to it is merged. Our current makefile system is kind of brittle in ways I didn't even realize until I used earthly.

from headway.

Yeah, well, tuning is for huge databases, not so much so for city stacks.
It will be enough to have a Postgres+Postgis docker container (which we currently have here).

from headway.

As per the makefile being brittle, yes, that is also my impression: even with a powerful server, we faced interruptions on big city installs (Paris or NYC) and had to relaunch the make a couple times.

from headway.

Yeah, well, tuning is for huge databases, not so much so for city stacks. It will be enough to have a Postgres+Postgis docker container (which we currently have here).

Definitely. That's why I haven't really gotten around to it.

As per the makefile being brittle, yes, that is also my impression: even with a powerful server, we faced interruptions on big city installs (Paris or NYC) and had to relaunch the make a couple times.

Yeah, it's kind of a bummer. I'm really hoping Earthly helps things out there!

from headway.

Just as a heads-up, #88 would remove postgres entirely. There's still the question of how to separate out the elasticsearch cluster though, because all of the same arguments in #83 (comment) still apply.

from headway.

I think I'm going to close this. Headway doesn't use postgres anymore but if anyone wants to try and extract the ES cluster from the pelias stack I'm all ears. :)

from headway.