PostgreSQL now comes with Server on 10.8+. However, postgres seems to require restarting often. How can I keep postgres running without having to restart it so often?
Not sure if it's the same in Mountain Lion Server, but perhaps this will help:
Disable automatic application termination in OS X http://hints.macworld.com/article.php?story=20120726192014497