Re: how to install postgresql ip4r

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxx
https://lists.centos.org/mailman/listinfo/centos



[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux