As PostgreSQL has been installed launchctl takes responsibility to take care of always running PostgreSQL daemon. /Library/LaunchDaemons/com.edb.launchd.postgresql-9.0.plist file sets up the daemon's behavior.
There are two options that can prevent the daemon after start up.
<key>Disabled</key> <false/> <key>RunAtLoad</key> <true/>
„Disabled”=True prevents the job from loading at all and there will be not possible start the job even manually.
„RunAtLoad”=Fasle tells the launchctl not to run the job after loading.
Here we are, set „RunAtLoad” to False and the daemon won't be run automatically.
By the way, there are useful commands below to run and stop the daemon though:
sudo launchctl list | grep postgresqldisplay current daemon's pid or exit code.
sudo launchctl start com.edb.launchd.postgresql-9.0start the daemon
sudo launchctl stop com.edb.launchd.postgresql-9.0and stop it
Not so far I have found new cool tool to work with postgresql on mac os x - Valentina Studio. Its free edition can do things more than many commercial tools!!
ReplyDeleteI very recommend check it. http://www.valentina-db.com/en/valentina-studio-overview
You can install Valentina Studio (FREE) directly from Mac App Store: https://itunes.apple.com/us/app/valentina-studio/id604825918?ls=1&mt=12