Details

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.