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@home1p /home/jason]$scl enable rh-postgresql95 bash [root@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@HOME1P jason]# service rh-postgresql95-postgresql start Starting rh-postgresql95-postgresql service: [ OK ] [root@HOME1P jason]# psql psql: FATAL: role "root" does not exist [root@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 installthen
psql -f /path/to/ip4r.sql dbnameto 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.