postgresql

Install munin and dependencies.
sudo aptitude install munin munin-node munin-plugins-extra libdbd-pg-perl

Let munin make suggestions for you.
sudo munin-node-configure --suggest| grep postgres

The above should reply with several lines similar to this.  read more »

Plugin                     | Used | Suggestions                            
------                     | ---- | -----------  
postgres_bgwriter          | no   | yes                                    
postgres_cache_            | no   | yes (+ALL +gis)  

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 »