[CentOS] how to install postgresql ip4r

[John R Pierce]

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 
requires.

but the ip4r release notes suggest...

     make NO_EXTENSION=1
     make NO_EXTENSION=1 install

then

     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