psycopg2 on snow leopard has been notoriously fucked forever. There are thousands of blog posts on installing this, of which only one has worked for me in the past.

This, granted, wasn't through homebrew; I wonder if that would have worked back then