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.

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].

Pages

Subscribe to weait.com RSS