to change the postgres cluster to a mounted destinatinon+ osmosis writes in /tmp so ln required

gistfile1.txt

sudo mkdir /home/ubuntu/working/postgre_data
sudo chown postgres /home/ubuntu/working/postgre_data/
sudo chmod -R 700 /home/ubuntu/working/postgre_data/
sudo pg_dropcluster 9.2 main --stop
sudo pg_createcluster 9.2 main -d /home/ubuntu/working/postgre_data/

sudo su postgres
pg_ctlcluster 9.2 main start
exit

sudo sed -i 's/peer/trust/g' /etc/postgresql/9.2/main/pg_hba.conf
sudo sed -i 's/md5/trust/g' /etc/postgresql/9.2/main/pg_hba.conf
/usr/lib/postgresql/9.2/bin/pg_ctl -D /etc/postgresql/9.2/main start

mkdir /home/ubuntu/tmp
cd /
rm -r tmp
sudo ln -s /home/ubuntu/working/tmp tmp