Re: Yosemite (OSX 10.0) problems with Postgresql

On Oct 20, 2014, at 4:26 AM, Jerry Levan <jerry(dot)levan(at)gmail(dot)com> wrote:
> 2) SystemStarter is no longer available. Gulp… I am not a very good plist creator.
> Is there a fairly generic plist I can edit to specify my locations of the
> software bits so I can have postgresql started at boot time?

I'm not familiar with SystemStarter, but here is the plist file that I've been using on several of my machines to start my own copy of postgres. Modified from the copy that comes with apple's server.app. This file goes in /Library/LaunchDaemons, and then can be loaded with the command

sudo launchctl load -w /Library/LaunchDaemons/<whatever you named the file.plist>

substitute load with unload to stop postgres.

<?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>Label</key>
<string>org.postgresql.postgres-mine</string>
<key>ProgramArguments</key>
<array>
<string>/usr/local/pgsql/bin/postmaster</string>
<string>-D</string>
<string>/usr/local/pgsql/data</string>
<string>-h</string>
<string>*</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>UserName</key>
<string>_postgres</string>
</dict>
</plist>

-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------

>
> Thanks,
>
> Jerry
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general