To setup a localised mapnik

Regionalisedmap.sql

-- Original http://wiki.openstreetmap.org/wiki/Regionalisedmap
CREATE view planet_ptosm_line as select
    osm_id,
    access,
    "addr:housename",
    "addr:housenumber",
    "addr:interpolation",
    admin_level,
    aerialway,
    aeroway,
    amenity,
    area,
    barrier,
    bicycle,
    brand,
    bridge,
    boundary,
    building,
    construction,
    covered,
    culvert,
    cutting,
    denomination,
    disused,
    embankment,
    foot,
    "generator:source",
    harbour,
    highway,
    historic,
    horse,
    intermittent,
    junction,
    landuse,
    layer,
    leisure,
    lock,
    man_made,
    military,
    motorcar,
    case when "name:pt" is not null then "name:pt" else name end as name,
    "natural",
    office,
    oneway,
    operator,
    place,
    population,
    power,
    power_source,
    public_transport,
    railway,
    ref,
    religion,
    route,
    service,
    shop,
    sport,
    surface,
    toll,
    tourism,
    "tower:type",
    tracktype,
    tunnel,
    water,
    waterway,
    wetland,
    width,
    wood,
    z_order,
    way_area,
    tags,
    way
from planet_osm_line;
CREATE view planet_ptosm_point as select
    osm_id,
    access,
    "addr:housename",
    "addr:housenumber",
    "addr:interpolation",
    admin_level,
    aerialway,
    aeroway,
    amenity,
    area,
    barrier,
    bicycle,
    brand,
    bridge,
    boundary,
    building,
    capital,
    construction,
    covered,
    culvert,
    cutting,
    denomination,
    disused,
    ele,
    embankment,
    foot,
    "generator:source",
    harbour,
    highway,
    historic,
    horse,
    intermittent,
    junction,
    landuse,
    layer,
    leisure,
    lock,
    man_made,
    military,
    motorcar,
    case when "name:pt" is not null then "name:pt" else name end as name,
    "natural",
    office,
    oneway,
    operator,
    place,
    population,
    power,
    power_source,
    public_transport,
    railway,
    ref,
    religion,
    route,
    service,
    shop,
    sport,
    surface,
    toll,
    tourism,
    "tower:type",
    tunnel,
    water,
    waterway,
    wetland,
    width,
    wood,
    z_order,
    tags,
    way
from planet_osm_point;
CREATE view planet_ptosm_polygon as select
    osm_id,
    access,
    "addr:housename",
    "addr:housenumber",
    "addr:interpolation",
    admin_level,
    aerialway,
    aeroway,
    amenity,
    area,
    barrier,
    bicycle,
    brand,
    bridge,
    boundary,
    building,
    construction,
    covered,
    culvert,
    cutting,
    denomination,
    disused,
    embankment,
    foot,
    "generator:source",
    harbour,
    highway,
    historic,
    horse,
    intermittent,
    junction,
    landuse,
    layer,
    leisure,
    lock,
    man_made,
    military,
    motorcar,
    case when "name:pt" is not null then "name:pt" else name end as name,
    "natural",
    office,
    oneway,
    operator,
    place,
    population,
    power,
    power_source,
    public_transport,
    railway,
    ref,
    religion,
    route,
    service,
    shop,
    sport,
    surface,
    toll,
    tourism,
    "tower:type",
    tracktype,
    tunnel,
    water,
    waterway,
    wetland,
    width,
    wood,
    z_order,
    way_area,
    tags,
    way
from planet_osm_polygon;
CREATE view planet_ptosm_roads as select
    osm_id,
    access,
    "addr:housename",
    "addr:housenumber",
    "addr:interpolation",
    admin_level,
    aerialway,
    aeroway,
    amenity,
    area,
    barrier,
    bicycle,
    brand,
    bridge,
    boundary,
    building,
    construction,
    covered,
    culvert,
    cutting,
    denomination,
    disused,
    embankment,
    foot,
    "generator:source",
    harbour,
    highway,
    historic,
    horse,
    intermittent,
    junction,
    landuse,
    layer,
    leisure,
    lock,
    man_made,
    military,
    motorcar,
    case when "name:pt" is not null then "name:pt" else name end as name,
    "natural",
    office,
    oneway,
    operator,
    place,
    population,
    power,
    power_source,
    public_transport,
    railway,
    ref,
    religion,
    route,
    service,
    shop,
    sport,
    surface,
    toll,
    tourism,
    "tower:type",
    tracktype,
    tunnel,
    water,
    waterway,
    wetland,
    width,
    wood,
    z_order,
    way_area,
    tags,
    way
from planet_osm_roads;
INSERT INTO geometry_columns VALUES ('gis', 'public', 'planet_cyosm_point', 'way', 2, 900913, 'POINT');
INSERT INTO geometry_columns VALUES ('gis', 'public', 'planet_cyosm_line', 'way', 2, 900913, 'LINESTRING');
INSERT INTO geometry_columns VALUES ('gis', 'public', 'planet_cyosm_polygon', 'way', 2, 900913, 'POLYGON');
INSERT INTO geometry_columns VALUES ('gis', 'public', 'planet_cyosm_roads', 'way', 2, 900913, 'LINESTRING');