[CentOS] how to install postgresql ip4r

Thu Nov 3 14:58:29 UTC 2016
Jason Welsh <jason.welsh at mercurygate.com>

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

following the instructions at


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 
[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?


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.