postGIS

I'm experimenting with importing the OSM database to a solid state disk. I hear they can be pretty fast. I expect it will take time to get the configuration right.

Default settings, mounted with noatime

First try it with all settings as default as possible. Mount the ssd with noatime to reduce writes to the ssd.  read more »

fdisk whole disk as one partition
mke2fs -t ext3 /dev/sdd1
# /etc/fstab
/dev/sdd1  /ssd  ext3   noatime  0 0 
# create tablespace on ssd
# create db on tablespace  

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

Create a user for this database. Perhaps replace username with your username? Sure.  read more »