UPDATE: Feb 28, 2008

If you are like me, you probably like databases to be FAST.
In my case, running a self-built cluster of postgres databases, means that the master DB 
needs to "resync" every once in a while to the slaves.
This usually means a very fast "REIMPORT" is needed.

To accomplish FAST reimports using postgres, on solaris, I usually relocate the pg_xlog folder to /tmp/
and I set up a symlink to the database folder.

Now, if by some reason the machine reboots, and you lose the pg_xlog, 

do this

1. remake your symlink
2. pg_resetxlog -f /data1/postgres824   (that was the data folder in my case)
3. PTG
4. start the database (pg_ctl start)
5. (you may have to remove the .pid lockfile, the thingy will tell you, and restart)
6. pg_ctl stop (clean  stop)
7. pg_ctl start


Looking good !