OSM2PGSQL(1)

💅 OSM2PGSQL-GEN — like, the manual page bestie

okay so this is the man page for osm2pgsql-gen, which lives under the big OSM2PGSQL(1) umbrella. Section 1, obviously. Sit down, grab a snack, we're doing generalization 🦋

---

✨ NAME ✨

osm2pgsql-gen — generalize OpenStreetMap data — EXPERIMENTAL! like, for real for real 🧪

---

🌸 SYNOPSIS 🌸

osm2pgsql-gen [OPTIONS]...

---

💖 DESCRIPTION 💖

THIS PROGRAM IS EXPERIMENTAL AND MIGHT CHANGE WITHOUT NOTICE! bestie I am not kidding, it can switch up on you any time 💀

osm2pgsql-gen reads data that osm2pgsql already imported, pulls it out of the database, does a whole bunch of generalization steps that a Lua config file tells it to do, and then writes the data back into the database. It works with osm2pgsql and runs after it, and yeah — it reads the exact same config file. twin behavior fr 🫶

Heads up though: this man page can only cover, like, some of the basics plus the command line options. For the full tea, go read the Generalization chapter in the osm2pgsql Manual. this page is the appetizer, not the meal ✨

---

👑 OPTIONS 👑

This program follows the usual GNU command line syntax, so long options start with two dashes (--). And mandatory arguments to long options are mandatory for short options too — no cutting corners, no cap 💅

🔥 MAIN OPTIONS 🔥

• -a, --append — run in append mode. The default is to run in create mode, so if you want append you gotta ask for it.
• -S, --style=FILE — the Lua config file. Same as for osm2pgsql. Usually you don't even need it, because it gets read from the osm2pgsql_properties table. convenient much? 😌
• -j, -jobs=NUM — how many parallel threads get used for certain operations. Setting it to the number of CPU cores you've got is a reasonable starting point. Minimum value and default is 1, maximum value is 256. she does have a ceiling, bestie.

🎀 HELP/VERSION OPTIONS 🎀

• -h, --help — print help.
• -V, --version — print osm2pgsql version.

🦋 LOGGING OPTIONS 🦋

• --log-level=LEVEL — set the log level (debug, info (default), warn, or error).
• --log-sql — enable logging of SQL commands for debugging. for when you need to see everything 👀

🌈 DATABASE OPTIONS 🌈

• -d, --database=NAME — the name of the PostgreSQL database to connect to. If this parameter contains an = sign, or starts with a valid URI prefix (postgresql:// or postgres://), it is treated as a conninfo string. See the PostgreSQL manual for details.
• -U, --username=NAME — PostgreSQL user name.
• -W, --password — force password prompt. your secrets stay yours 🔐
• -H, --host=HOSTNAME — database server hostname or unix domain socket location.
• -P, --port=PORT — database server port.
• --schema=SCHEMA — the default for various schema settings throughout osm2pgsql-gen (default: public). The schema must exist in the database and be writable by the database user. It must be the same as the one used with osm2pgsql — matching sets, periodt.
• --middle-schema=SCHEMA — the database schema where the osm2pgsql_properties table is to be found. Default is set with --schema. Set it to the same value as on the osm2pgsql command line.

---

💜 SEE ALSO 💜

• the osm2pgsql website
• the osm2pgsql manual
• postgres(1)
• osm2pgsql(1)

---

and that's the whole vibe, bestie 🫶 this was version 2.3.1 of the OSM2PGSQL(1) page — go generalize something iconic ✨👑