Postgresql 8.4.8 recipe for homebrew, lives in /usr/local/Library/Formula/postgresql.rb

postgresql.rb

require 'formula'
require 'hardware'

class Postgresql <Formula
  homepage 'http://www.postgresql.org/'
  url 'http://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/source/v8.4.8/postgresql-8.4.8.tar.bz2'
  md5 '4603e8ea30cee97189b62b39022f2043'

  depends_on 'readline'
  depends_on 'libxml2' if MACOS_VERSION < 10.6 #system libxml is too old

  aka 'postgres'

  def options
    [
      ['--no-python', 'Build without Python support.'],
      ['--no-perl', 'Build without Perl support.']
    ]
  end

  def install
    ENV.libxml2 # wouldn't compile for justinlilly otherwise
    
    configure_args = [
        "--enable-thread-safety",
        "--with-bonjour",
        "--with-gssapi",
        "--with-krb5",
        "--with-openssl",
        "--with-libxml",
        "--with-libxslt",
        "--prefix=#{prefix}",
        "--disable-debug"
    ]

    configure_args << "--with-python" unless ARGV.include? '--no-python'
    configure_args << "--with-perl" unless ARGV.include? '--no-perl'

    if bits_64? and not ARGV.include? '--no-python'
      configure_args << "ARCHFLAGS='-arch x86_64'"

      # On 64-bit systems, we need to look for a 32-bit Framework Python.
      # The configure script prefers this Python version, and if it doesn't
      # have 64-bit support then linking will fail.

      framework_python = Pathname.new "/Library/Frameworks/Python.framework/Versions/Current/Python"
      if framework_python.exist? and not (archs_for_command framework_python).include? :x86_64
        opoo "Detected a framework Python that does not have 64-bit support in:"
        puts <<-EOS.undent
            #{framework_python}

          The configure script seems to prefer this version of Python over any others,
          so you may experience linker problems as described in:
            http://osdir.com/ml/pgsql-general/2009-09/msg00160.html

          To fix this issue, you may need to either delete the version of Python
          shown above, or move it out of the way before brewing PostgreSQL.

          Note that a framework Python in /Library/Frameworks/Python.framework is
          the "MacPython" verison, and not the system-provided version which is in:
            /System/Library/Frameworks/Python.framework
        EOS
      end
    end

    # Fails on Core Duo with O4 and O3
    ENV.O2 if Hardware.intel_family == :core

    system "./configure", *configure_args
    system "make install"

    (prefix+'org.postgresql.postgres.plist').write startup_plist
    (prefix+'org.postgresql.postgres.plist').chmod 0644
  end

  def skip_clean? path
    # NOTE at some point someone should tweak this so it only skips clean
    # for the bits that break the build otherwise
    true
  end

  def bits_64?
    MACOS_VERSION >= 10.6 && Hardware.is_64_bit?
  end

  def caveats
    caveats = <<-EOS
To build plpython against a specific Python, set PYTHON prior to brewing:
  PYTHON=/usr/local/bin/python  brew install postgresql
See:
  http://www.postgresql.org/docs/8.4/static/install-procedure.html


If this is your first install, create a database with:
    initdb #{var}/postgres

Automatically load on login with:
    launchctl load -w #{prefix}/org.postgresql.postgres.plist

Or start manually with:
    pg_ctl -D #{var}/postgres -l #{var}/postgres/server.log start

And stop with:
    pg_ctl -D #{var}/postgres stop -s -m fast
EOS
    
    if bits_64? then
      caveats << <<-EOS

If you want to install the postgres gem, including ARCHFLAGS is recommended:
    env ARCHFLAGS="-arch x86_64" gem install postgres

To install gems without sudo, see the Homebrew wiki.
      EOS
    end

    caveats
  end

  def startup_plist
    return <<-EOPLIST
<?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>KeepAlive</key>
  <true/>
  <key>Label</key>
  <string>org.postgresql.postgres</string>
  <key>ProgramArguments</key>
  <array>
    <string>#{bin}/postgres</string>
    <string>-D</string>
    <string>#{var}/postgres</string>
    <string>-r</string>
    <string>#{var}/postgres/server.log</string>
  </array>
  <key>RunAtLoad</key>
  <true/>
  <key>UserName</key>
  <string>#{`whoami`.chomp}</string>
  <key>WorkingDirectory</key>
  <string>#{HOMEBREW_PREFIX}</string>
  <key>StandardErrorPath</key>
  <string>#{var}/postgres/server.log</string>
</dict>
</plist>
    EOPLIST
  end
end