Page History

...

Eventually, I'll be incorporating specific Mac OS 10.6 related instructions into this wiki page, but for now, I've verified that these instructions (http://) work with Mac OS 10.6 (Snow Leopard) and PostgreSQL 9.0.3. Do note the typo in the section containing information on setting up the operating system's "postgres" user. The instructions say "sudu" instead of "sudo" on all but the first line. Also, the configuration options are fairly generic aside from the Mac OSX specific locations and the bonjour flag and could be used as the basis for setting up postgres in other linux / unix environments (save, again, for setting up the operating system's postgres user).

/Library/LaunchDaemons/org.postgresql.PostgreSQL.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>org.postgresql.PostgreSQL</string>
    <key>ServiceDescription</key><string>PostgreSQL Database Server</string>
    <key>Disabled</key><false/>
    <key>Username</key><string>postgres</string>
    <key>Groupname</key><string>postgres</string>
    <key>Program</key><string>/usr/local/pgsql/bin/pg_ctl</string>
    <key>ProgramArguments</key>
    <array>
      <string>-D</string>
      <string>/usr/local/pgsql/data</string>
      <string>-l</string>
      <string>/usr/local/pgsql/data/server.log</string>
      <string>start</string>
    </array>
    <key>KeepAlive</key><false/>
    <key>RunAtLoad</key><true/>
  </dict>
</plist>

Oracle

I've not verified them, but you'll likely meet with success using these instructions for working with Oracle 10g on Mac OS 10.6.

...