Client Portal

Quick PostGIS and DbLink install on cPanel server with PostgreSQL 9.1

PostGIS If you try 'yum install postgis91 postgis91-utils geos proj' yum will complain about inability to install DBD::Pg module already provided by cPanel. So we get packages manually: wget http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/postgis91-utils-1.5.5-1.rhel5.x86_64.rpmwget http://yum.postgresql.org/9.1/redhat/rhel-5-x86_64/postgis91-1.5.5-1.rhel5.x86_64.rpmrpm --nodeps -Uvh postgis91-1.5.5-1.rhel5.x86_64.rpm postgis91-utils-1.5.5-1.rhel5.x86_64.rpm yum install geos projcreatedb pgisdbpsql -d pgisdb -f /usr/pgsql-9.1/share/contrib/postgis-1.5/postgis.sqlpsql -d pgisdb -f /usr/pgsql-9.1/share/contrib/postgis-1.5/spatial_ref_sys.sql DbLink Make sure the contrib package is installed, e.g. from your shell: yum install postgres*contrib Then create the extension from psql shell psql> CREATE EXTENSION dblink;