OpenStreetMap postgresql postGIS database on RAID

rweait's picture

Configure a database for OpenStreetMap on another disk

Perhaps you need more space for your OpenStreetMap database and decide to move it to your shiny new big disk or RAID array? Sound good? Here we go. We need to create a tablespace for the database, then use it.

Create a directory for the database
sudo mkdir /raid/newgis
sudo chown postgres:postgres /raid/newgis

As the postgres user
sudo -u postgres -i

Install RAID0 on Ubuntu Lucid Lynx

rweait's picture

set up RAID0

Create a full-disk partition on each of two drives to be RAID0 combined. Set each full-disk partition as type fd - Linux RAID Auto-detect. Use fdisk or your favourite partitioning tool.

Then:
mdadm --create /dev/md0 --level=0 --raid-devices=2 /dev/sda1 /dev/sdb1
sudo /usr/share/mdadm/mkconf force-generate /etc/mdadm/mdadm.conf
sudo mkfs.ext3 /dev/md0
mkdir /raid
sudo mount /dev/md0 /raid

Everything okay to this point? Add the raid to fstab to mount raid automatically after reboot.

LocationTech resources

rweait's picture

Resources for the 05 February 2013, Introduction to OpenStreetMap talk for LocationTech are found here. These resources are either, materials that were unsuited to the videoconference format, or are related to questions raised during the question and answer session.

City animation - OpenStreetMap data, over time, in Toronto.
animation of OSM data added in Toronto over time.

Take a Drive

rweait's picture

golf course rendering on Open.MapQuest.com

I like the cartography on http://open.MapQuest.com . The style differs from our mapnik and osmarender styles by rendering fewer types of objects and by using subtler colors. It's different. Their selectable thematic layers are great and let you add objects to the map that interest you at the moment. That's all pretty cool and that's not what I started this article to talk about.

I want to talk about golf.

Trade mark 2

rweait's picture
header from the cipo web site

Based on the draft board minutes OSMF has received a C&D based on a registered trade mark[0]. It seems to be a valid registration, whether I think it is a stupid registration or not. This is some background on trade marks as they relate to C&Ds. You'd be stupid to take this as legal advice. It's only food for thought[1].

Golf course style for OpenStreetMap

rweait's picture

photo ccby chispita from flickr
In July 2009, Peter Miller wondered aloud on the OpenStreetMap-talk mailing list, if detailed rendering of golf courses was coming to OpenStreetMap? It's a fair question and one that has run through the mind of any OpenStreetMap enthusiast who has spent an afternoon at a good walk ruined.[1]

Pages

Subscribe to weait.com RSS