[OSM-talk] Building a tile-server

[Tom Browder]

On Wed, Jul 1, 2020 at 15:18 Tom Browder <tom.browder at gmail.com> wrote:
> Yesterday I took my first try at using osm2pgsql on a pbm file and,
> too late, I realized I didn't take full advantage of the server's
> large RAM and multi-core capability.
...

Okay, I'm making progress, thanks to you all.

First, lesson learned (as suggested by all): I used Antarctica pbm as
a test bed for import which showed an immediate problem with
osm2pgsql.

Thanks to Sarah about the requirement for a current osm2pgsql. I wound
up compiling and installing from source which made the import process
work. Strangely, that version shows as 1.2.0 while the Buster
backports shows version 1.21!

Thanks to Paul for the postgresql settings I made for work_mem and
maintenance_work_mem (and the size catch by Martin!).

As to suggestions to change other postgresql settings I got mixed
signals.  One I didn't ask about was autovacuum on or off?

I plan to try Frederik's tirex at some point after I get a working server.

Finally, thanks to Julien for the links to his vector tile work.  I
will have to study that a bit more later.

Cheers!

-Tom