[Gnumed-devel] Re: Postgresql installation on OS X

[Jim Busser]

the following is still re Enterprisedb

On 2010-06-30, at 5:31 AM, Dave Cramer wrote:

>> I have a client who is having some trouble with the binary for OS X
> 
> /Library/LaunchDaemons/

Thanks Dave. I did locate, in the above,

        /Library/LaunchDaemons/com.edb.launchd.postgresql-8.4.plist

re the following, which I broke by deleting the old postgres directory

        sudo SystemStarter start PostgreSQL

I now understand Mac OS X "SystemStarter" to be deprecated
        
http://developer.apple.com/mac/library/documentation/Darwin/Reference/ManPages/man8/SystemStarter.8.html

so I can happily learn more about how the launch daemon is managed.

>> Where does the installer put the startup item, and where does it put
>> the binaries, data ?
> 
> By default, under /Library/PostgreSQL/X.Y/ and
> /Library/PostgreSQL/X.Y/data, but those locations are options in the
> installer so the user may have changed them.

no, I left them as above. Contained therein include

        /Library/PostgreSQL/8.4/scripts/start.applescript
        /Library/PostgreSQL/8.4/scripts/stop.applescript

which work.. the "start" script contains
        set ret to do shell script "su - postgres -c 
\"/Library/PostgreSQL/8.4/bin/pg_ctl start -w -D /Library/PostgreSQL/8.4/data\" 
> /tmp/pgmsg.txt 2>&1" with administrator privileges 

so I can likely run further than I believed, with enterprisedb :-) ...

-- Jim