Skip to main content

Posts

Showing posts with the label FDW

Installing Multicorn on RHEL6

The Multicorn project makes it possible to write Foreign Data Wrappers for PostgreSQL in Python. To install Multicorn on RHEL6 the following is needed: PostgreSQL 9.2 Python 2.7 make, GCC, etc. Installing PostgreSQL 9.2 is easy as it's available in the PostgreSQL Yum repository . Unfortunately Python 2.7 is not included in RHEL6. And replacing the 'system' python is a bad idea. The solution is to do an 'altinstall' of Python. The "--shared" and ucs4 options are required. The altinstall will install a python binary with the name python2.7 instead of just python. This allows you to have multiple python versions on 1 system. wget http://www.python.org/ftp/python/2.7.3/Python-2.7.3.tgz tar zxf Python-2.7.3.tgz cd Python-2.7.3 ./configure --shared --enable-unicode=ucs4 make make altinstall This will result in a /usr/local/bin/python2.7 which doesn't work. This is due to the fact that the libraries are installed /usr/local/lib, which is...