Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save peteyan/e9eea2f6577e63d8b92585217970c3c9 to your computer and use it in GitHub Desktop.
Save peteyan/e9eea2f6577e63d8b92585217970c3c9 to your computer and use it in GitHub Desktop.
Disable/Enable PostgreSQL Autostart on Mac OS X Lion
<?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>
## 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)
@peteyan
Copy link
Author

peteyan commented May 2, 2021

Used for postgres 13, macOS big sur.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment