You are here

Home › Installing Theatre Manager › PostgreSQL Database Server › Macintosh PostgreSQL Server

Server Power Saving Settings

Subscribe to Syndicate
Sat, 03/12/2011 - 13:11 — David

Additional Setup Considerations

The following settings should be made on all servers (postgres, apache and web listeners) that are installed on Macintosh.

1 Make sure to turn off all energy saving options such as prevent hard disk sleep, do not allow the CPU to go into low processor mode, etc.
2 Make sure to turn airport OFF if the Mac comes with it. Airport will cause the mac to temporarily freeze while it looks for a network to connect to - and will lock out sales while it does that.

This is done by opening the control panel, clicking on the airport interface and then clicking on the 'gear' at the bottom to select the option 'make service inactive'. If you do this, the status will go from 'off' to 'inactive'

3 Make sure to physically plug in a Monitor to the Mac -or- connect a KVM switch into it that is powered up. If you disconnect a monitor from the Mac, it will stop working as a listener and web sales appear frozen. (it is an OSX thing)
4 Turn off Spotlight Indexing on Snow Leopard using

sudo mdutil -a -i off

On Lion, use the following command

sudo launchctl unload -w /System/Library/LaunchDaemons/com.apple.metadata.mds.plist

This will prevent the operating system doing un-neccessary work while serving web pages. you will know if Spotlight is running on a server if you see the 'mds' application running. It can take a lot of CPU.

5 Do not use the postgres server for Time Machine backups - use the backup script and move the backups to another machine