aboutsummaryrefslogtreecommitdiffstats
path: root/Library/Formula/pgbouncer.rb
blob: 15b1cd10f2355b53267aca1ce7becce5adad3c26 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
require 'formula'

class Pgbouncer < Formula
  url 'http://pgfoundry.org/frs/download.php/3085/pgbouncer-1.4.2.tgz'
  homepage 'http://wiki.postgresql.org/wiki/PgBouncer'
  md5 '5083110b5b4f2127234bfc7b1f451f8d'

  depends_on 'libevent'

  def install
    system "./configure", "--disable-debug", "--disable-dependency-tracking",
                          "--with-libevent=#{HOMEBREW_PREFIX}",
                          "--prefix=#{prefix}"
    system "make install"
    bin.install "etc/mkauth.py"
    etc.install %w(etc/pgbouncer.ini etc/userlist.txt)

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

  def caveats
    s = <<-EOS
The config file: #{etc}/pgbouncer.ini is in the "ini" format and you
will need to edit it for your particular setup. See:
http://pgbouncer.projects.postgresql.org/doc/config.html

The auth_file option should point to the #{etc}/userlist.txt file which
can be populated by the #{bin}/mkauth.py script.

If this is your first install, automatically load on login with:
    mkdir -p ~/Library/LaunchAgents
    cp #{prefix}/org.postgresql.pgbouncer.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/org.postgresql.pgbouncer.plist

If this is an upgrade and you already have the org.postgresql.pgbouncer.plist
loaded:
    launchctl unload -w ~/Library/LaunchAgents/org.postgresql.pgbouncer.plist
    cp #{prefix}/org.postgresql.pgbouncer.plist ~/Library/LaunchAgents/
    launchctl load -w ~/Library/LaunchAgents/org.postgresql.pgbouncer.plist

Or start manually with:
    pgbouncer -q #{etc}/pgbouncer.ini
    EOS
  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.pgbouncer</string>
  <key>ProgramArguments</key>
  <array>
    <string>#{bin}/pgbouncer</string>
    <string>-d</string>
    <string>-q</string>
    <string>#{etc}/pgbouncer.ini</string>
  </array>
  <key>RunAtLoad</key>
  <true/>
  <key>UserName</key>
  <string>#{`whoami`.chomp}</string>
  <key>WorkingDirectory</key>
  <string>#{HOMEBREW_PREFIX}</string>
</dict>
</plist>
    EOPLIST
  end
end