create a complex extension
For example : create a postgis
if you install postgis at first, there are some information as viewed below:
Geos-config not found
gdal-config not found
Sudo apt install libgdal-dev
You should install proj and geos first
install proj
1 | tar -xvzf proj-4.8.0.tar.gz |
install postgis
tar -xvzf postgis-1.5.4.tar.gz
cd postgis-1.5.4
./configure --with-pgconfig=/usr/local/pgsql/bin/pg_config --with-projdir=/usr/local/proj --with-geosconfig=/usr/local/geos/bin/geos-config
pg_ctl -D /data/pgsql/ -l /data/pgsql/pgsql.log start
createdb template_postgis
psql -f /usr/local/pgsql/share/contrib/postgis-1.5/postgis.sql -d template_postgis
psql template_postgis
select postgis_full_version();