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