[OSM-dev] ER Diagram of OSM Database
andi at saerdnaer.de
Mon Dec 12 23:14:57 GMT 2011
Am 12.12.2011 um 19:50 schrieb Parveen Arora:
> I was searching for ER Diagram of OpenStreetMap's Database to
> understand completely,
I think the best way is to understand the different parts step by step and not to try to understand everything at the first time.
> I found one component diagram
> But I want one only of database?
There is not one database. The main services provided by the foundation actually use two different databases, as shown in the component overview you already found.
Green: PostgreSQL backend
aliases: api db, main db, core db
aliases: osm2pgsql db, Mapnik db
We should definitely discuss about using uniform names in future.
An overview about the different database schemas is available at
> or Please let me know how to generate it automatically from PostGreSQL Database?
Please state which "PostgreSQL" database you mean. Both databases are hosted on PostgreSQL databases servers.
More information about the dev