The URL changed appears, but the formula has not yet been updated.
The formula is now updated. Instead of manually committing the recipe, as the rest of this answer says, just update your homebrew recipes via brew update
and try installing again.
You can edit the formula yourself using the brew edit postgresql
command. Change url
to http://ftp.postgresql.org/pub/source/v9.1.1/postgresql-9.1.1.tar.bz2
and try installing again.
source share