Created
March 2, 2012 19:56
-
-
Save abhishekdev/1960888 to your computer and use it in GitHub Desktop.
Disable/Enable PostgreSQL Autostart on Mac OS X Lion
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<!DOCTYPE plist PUBLIC "-//Apple Computer//DTD PLIST 1.0//EN" | |
"http://www.apple.com/DTDs/PropertyList-1.0.dtd"> | |
<plist version="1.0"> | |
<dict> | |
<key>Disabled</key> | |
<false/> | |
<key>Label</key> | |
<string>com.edb.launchd.postgresql-9.1</string> | |
<key>ProgramArguments</key> | |
<array> | |
<string>/Library/PostgreSQL/9.1/bin/postmaster</string> | |
<string>-D/Library/PostgreSQL/9.1/data</string> | |
</array> | |
<key>RunAtLoad</key> | |
<true/> | |
<key>UserName</key> | |
<string>postgres</string> | |
<key>KeepAlive</key> | |
<dict> | |
<key>SuccessfulExit</key> | |
<false/> | |
</dict> | |
</dict> | |
</plist> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
## Stop PostgreSQL from auto starting in Mac OS X 10.7.x (Lion) | |
sudo launchctl unload -w /Library/LaunchDaemons/com.edb.launchd.postgresql-9.1.plist | |
## Enable PostgreSQL to auto start in Mac OS X 10.7.x (Lion) | |
sudo launchctl load -w /Library/LaunchDaemons/com.edb.launchd.postgresql-9.1.plist | |
## Manually Start PostgreSQL | |
## su as user "postgres" and run server: | |
cd /Library/PostgreSQL/9.1/bin/ | |
./pg_ctl -D /Library/PostgreSQL/9.1/data/ start | |
## Manually Stop PostgreSQL | |
./pg_ctl -D /Library/PostgreSQL/9.1/data/ stop | |
## Note: | |
## - Without "sudo" the commands seem to run successfully but don't take effect | |
## - Contents of com.edb.launchd.postgresql-9.1.plist in attached file (Permission MUST be: -rw-r--r-- 1 root wheel) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment