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 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.
_______________________________________________
CentOS mailing list
CentOS@centos.org
https://lists.centos.org/mailman/listinfo/centos
