Skip site navigation (1) Skip section navigation (2)

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

From: Michael Kohout <mwkohout(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Snow Leopard-how to get PG 8.4 to start up on demand?
Date: 2010-02-06 19:19:52
Message-ID: 512044651002061119j605bc9e9s668aa5ba3f1b8471@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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?

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>

Responses

pgsql-general by date

Next:From: Enrico PirozziDate: 2010-02-06 20:11:50
Subject: Re: ODBC mac os
Previous:From: Merlin MoncureDate: 2010-02-06 18:00:00
Subject: adding libpq to pgbouncer breaks single handler

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group