CentOS - Nov 2016 - how to install postgresql ip4r

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)

Jason

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

ok, so I removed the default postgresql install and installed it from 
the software collections..

following the instructions at

https://www.softwarecollections.org/en/scls/rhscl/rh-postgresql95/


and I get this

[root at home1p /home/jason]$scl enable rh-postgresql95 bash
[root at HOME1P jason]#  postgresql-setup --initdb
  * Initializing database in
'/var/opt/rh/rh-postgresql95/lib/pgsql/data'
  * Initialized, logs are in 
/var/lib/pgsql/initdb_rh-postgresql95-postgresql.log
[root at HOME1P jason]#  service rh-postgresql95-postgresql start
Starting rh-postgresql95-postgresql service:               [  OK ]
[root at HOME1P jason]# psql
psql: FATAL:  role "root" does not exist
[root at HOME1P jason]#

any ideas?


Jason





On 11/02/2016 05:04 PM, John R Pierce wrote:
> 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.
>
>
>