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 !