Submitted by rw on Fri, 03/26/2010 - 21:26.
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 »