在ubuntu14.04上安装postgis1.5
目录
How to install PostGIS 1.5 on Ubuntu 14.04
我的项目比较老,原来用的是PosgGre9.1 +postgis1.5,新安装的时候找不到postgis1.5,只有2.0以上,我装了2.2,发现原来的数据备份不能导进去,也不能用原来的数据schema,也用不了了,怎么办呢,只呢去装postgis1.5,postgis1.5的地理信息相关的数据格式处理,在2.2里找不到了。
安装吧,找了一圈,一下步骤就来装吧
Several components are needed, which can either be built from source or installed from pre-built packages, as shown below.
1 ,如果你装了postgresql了,这一步就不用了,其实9.5也可以,不一定非要装8.4,Install prerequisite packages using:
sudo apt-get install build-essential postgresql-8.4 postgresql-server-dev-8.4 libxml2-dev proj
2,这个就是必须了 Optional packages for testing PostGIS:
sudo apt-get install libcunit1-dev
3,Optional packages for building documentation:
sudo apt-get install xsltproc docbook-xsl imagemagick
(for building PDF documentation, add dblatex, but expect a large download)
Build GEOS 3.3.x
PostGIS 1.5 requires GEOS >= 3.1.1, however Ubuntu 10.04 only has GEOS 3.1.0 available in packages, so it needs to be built from source.
There are multiple ways to build GEOS, but this is the simplest:
wget http://download.osgeo.org/geos/geos-3.3.8.tar.bz2 tar xvfj geos-3.3.8.tar.bz2 cd geos-3.3.8 ./configure make sudo make install
Build PostGIS
Download, configure, build and install:
wget http://download.osgeo.org/postgis/source/postgis-1.5.8.tar.gz
tar xfvz postgis-1.5.8.tar.gz
cd postgis-1.5.8
./configure
make
sudo make install
sudo ldconfig
Documentation/comments
From the postgis-1.5.8 directory:
cd doc make sudo make install sudo make comments-install
Template
Complete a post-install by creating a template, which can be re-used for creating multiple spatially-enabled databases. Or if you just want to make one spatially enabled database, you can modify the commands for your needs.
sudo -u postgres createdb template_postgis
sudo -u postgres createlang plpgsql template_postgis
sudo -u postgres psql -d template_postgis -c "UPDATE pg_database SET datistemplate=true WHERE datname='template_postgis'"
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql
sudo -u postgres psql -d template_postgis -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis_comments.sql
如果你装的是9.1以上就不一定非要用这个来测试,成功就好了,打开pgadmin,登录看看,远程也可哦!
See also ¶
转载自:https://blog.csdn.net/mingkiller/article/details/50952047