Postgresql formula

With most options enabled (why not?).

Could use cleanup perhaps, but it works...

Note that this does not work due to some library loading issues… when I run
initdb I get a big fail which I have yet to track down.

Signed-off-by: Max Howell <max@methylblue.com>

1 files changed, 56 insertions, 0 deletions

diff --git a/Library/Formula/postgresql.rb b/Library/Formula/postgresql.rb
new file mode 100644
index 000000000..c0e02a954
--- /dev/null
+++ b/Library/Formula/postgresql.rb
@@ -0,0 +1,56 @@
+require 'brewkit'
+
+class Postgresql <Formula
+  @url='http://wwwmaster.postgresql.org/redir/198/h/source/v8.4.0/postgresql-8.4.0.tar.bz2'
+  @homepage='http://www.postgresql.org/'
+  @md5='1f172d5f60326e972837f58fa5acd130'
+
+  def install
+
+    configure_args = [
+        "--with-bonjour",
+        "--with-python",
+        "--with-perl",
+        "--with-gssapi",
+        "--with-krb5",
+        "--with-openssl",
+        "--with-libxml",
+        "--with-libxslt",
+        "--prefix=#{prefix}",
+        "--disable-debug",
+        "--disable-dependency-tracking"
+    ]
+
+    system "./configure", *configure_args
+    system "make install"
+
+  end
+
+  def caveats
+    puts <<-EOS
+==============================================================
+Suggested next steps:
+
+    * Create a user for postgresql (we'll name it "postgres"). 
+    * Create a databse:
+    
+    $ sudo mkdir -p /var/db/postgresql/defaultdb
+    $ sudo chown postgres /var/db/postgresql/defaultdb
+    $ sudo su postgres -c '/usr/local/bin/initdb -D /var/db/postgresql/defaultdb'
+
+    $ sudo touch /var/log/postgres.log
+    $ sudo chown postgres /var/log/postgres.log
+
+Starting:
+
+    $ sudo su postgres -c "/usr/local/bin/pg_ctl -D /var/db/postgresql/defaultdb start -l /var/log/postgres.log"
+
+Stopping:
+
+    $ sudo su postgres -c "/usr/local/bin/pg_ctl -D /var/db/postgresql/defaultdb stop -s -m fast"
+
+Google around for org.postgresql.plist if you want launchd support.
+==============================================================
+    EOS
+  end
+end