OpenStreetMap is a free editable map of the whole world. OpenStreetMap allows you to view, edit and use geographical data in a collaborative way from anywhere on Earth.
This database, usable for tile rendering, map servers, analysis, and visualization, is the OpenStreetMap planet (Planet.osm) in a database cluster: thus it can easily be attached as a new database (including PostGIS language extensions) to any system with Postgres 8.3.
Immediately after mounting the volume, set the owner of the data files to postgres:
sudo chown -R postgres:postgres /mnt/sdk/data
And then proceed to run pg_createcluster. The database is called 'gis', so if the cluster is on port 5433, run:
su postgrespsql -p 5433 gis
And you should be connected to the database.
The main command to create and start a cluster based off of this image is
pg_createcluster -d /mnt/sdn/data 8.3 osm --start
Replacing the mountpoint and replacing 'osm' with your desired databasename. Note that Postgres clusters are started on different ports than the typical database, so pay attention to log messages and the resulting configuration files.
Data generated by the contributors to OpenStreetMap and licensed under CC-By-SA, this database maintained and updated by Development Seed