Re: Snow Leopard-how to get PG 8.4 to start up on demand?

On Sat, Feb 6, 2010 at 2:19 PM, Michael Kohout <mwkohout(at)gmail(dot)com> wrote:

> Hi All;
>
> I've got a development box that I use for a bunch of other purposes(mostly
> music), and I was wondering if there was a way to configure launchd to only
> start up postgres when it's needed. SSH does the same thing so I've tried
> to fashion a plist for this purpose modeled after that(on my box it's
> located at /System/Library/LaunchDaemons/ssh.plist) but something is wrong.
> PGAdmin 3 errors out when I try to connect.
>
> Below is my nonworking plist. Does anyone have any suggestions on what I'm
> doing wrong?
>

PostgreSQL is a relational database system, very different than an
on-demand type of service. The engine is really built to come online and
stay online. I wouldn't recommend setting your database up like this at
all. Remember, a database is very complex, and you have a lot of background
and maintenance processes that need to run.

As far as why it's dying, it's hard to say, but I don't see anything in your
config file about the port to listen on... is it that simple? I'm not sure,
but it's worth a look.

--Scott

>
> thanks
> Mike Kohout
>
> Fender-2:LaunchDaemons development$ cat ondemand.postgres8.4.plist <?xml
> version="1.0" encoding="UTF-8"?>
> <!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "
> http://www.apple.com/DTDs/PropertyList-1.0.dtd">
> <plist version="1.0">
> <dict>
> <key>Label</key>
> <string>ondemand.postgres8.4</string>
> <key>UserName</key>
> <string>development</string>
> <key>KeepAlive</key>
> <false/>
> <key>ProgramArguments</key>
> <array>
>
> <string>/Users/development/Applications/postgres-8.4.1/bin/pg_ctl</string>
> <string>start</string>
> <string>-D</string>
> <string>/Users/development/Documents/postgres_data</string>
> </array>
> <key>ServiceDescription</key>
> <string>Postgresql Server</string>
> <key>Sockets</key>
> <dict>
> <key>Listeners</key>
> <dict>
> <key>SockServiceName</key>
> <string>postgresql</string>
> </dict>
> </dict>
> <key>inetdCompatibility</key>
> <dict><key>Wait</key><true/></dict>
> </dict>
> </plist>
>
>