mxcl/homebrew — Issue #10247: Should we set dynamic_library_path in postgresql.conf?
Author: Sharpie
Created: 2012-02-17 02:38:02+00:00
State: open
Labels: postgres

Currently, there is a bit of an issue with PostgreSQL and Homebrew formulae that provide PostgreSQL extensions. The problem is that Postgres will only look for and load plugin libraries that are inside its `#{prefix}/lib` folder. This means that every formula that provides an extension library, such as PostGIS, has to install the libs into the Postgres keg.

This breaks uninstallation and upgrading of plugins because some components are never removed. One fix for the problem is to add `#{HOMEBREW_PREFIX}/lib` to the default value for `dynamic_library_path` in `postgresql.conf`. Then Postgres will pick up any plugin library that Homebrew symlinks into the global prefix.

Thoughts?