Re: Yosemite (OSX 10.0) problems with Postgresql - Mailing list pgsql-general

From Israel Brewster
Subject Re: Yosemite (OSX 10.0) problems with Postgresql
Date
Msg-id 658D8A0E-9CB1-4BE6-9472-6981D149F247@ravnalaska.net
Whole thread Raw
In response to Yosemite (OSX 10.0) problems with Postgresql  (Jerry Levan <jerry.levan@gmail.com>)
Responses Re: Yosemite (OSX 10.0) problems with Postgresql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Oct 20, 2014, at 4:26 AM, Jerry Levan <jerry.levan@gmail.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
myown 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general



pgsql-general by date:

Previous
From: Raghu Ram
Date:
Subject: Re: Yosemite (OSX 10.0) problems with Postgresql
Next
From: Craig Ringer
Date:
Subject: Re: Yosemite (OSX 10.0) problems with Postgresql