[CentOS] how to install postgresql ip4r

[John R Pierce]

On 11/3/2016 7:58 AM, Jason Welsh wrote:
> 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/

the best way to install postgresqol, imho, is from the 
yum.postgresql.com respoitory run by the postgresql development group.  
you get your choice of any of the active versions (9.2, 9.3, 9.4, 9,5, 
and now 9.6), it has almost all of the add-ons available at your 
fingertips via yum, and its well integrated and well supported.  It does 
require a few packages from the EPEL repository for some of the addon 
packages.

quicky howto on installing 9.5.latest for centos 6 64bit...

     # First, (optional) create and mount a dedicated xfs file system at 
/var/lib/pgsql before beginning this, so all my databases are on it
     sudo yum -y install 
https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-6-x86_64/pgdg-centos95-9.5-3.noarch.rpm
     sudo yum -y install postgresql95-{server,contrib,devel}   # install 
server and components
     sudo service postrgresql-9.5 initdb  # initialize database cluster
     sudo service postgresql-9.5 start    # start database server
     sudo chkconfig postgresql-9.5 on   # set so db server always runs 
at boot
     sudo -u postgres psql -c "create user $USER superuser; create 
database $USER owner $USER"

that last step gives your regular user a sql account with full database 
admin privs and creates a scratchpad database for them to log on with 
while doing admin stuff.

now,

     sudo yum -y install ip4r95
     psql -c "create extension ip4r" somedatabase

to install ip4r and enable it in somedatabase...




-- 
john r pierce, recycling bits in santa cruz