[CentOS] how to install postgresql ip4r

Wed Nov 2 21:04:21 UTC 2016
John R Pierce <pierce at hogranch.com>

On 11/2/2016 1:49 PM, Jason Welsh wrote:
> on the old postgresql that comes with centos 6?
> Ive asked google over and over and he wont tell me. :(
> (im trying to install it as a requirement for NIPAP) 

I don't think Postgres 8.4 has the infrastructure that ip4r extension 

but the ip4r release notes suggest...

     make NO_EXTENSION=1
     make NO_EXTENSION=1 install


     psql -f /path/to/ip4r.sql dbname

to activate it in that dbname database.   they also mention there's 
quite a bit of stuff in ip4r that won't work on pre-9.1 Postgres due to 
lack of indexing support.

john r pierce, recycling bits in santa cruz