search for: ip4r

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) Jason

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

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

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