ubuntu源码安装postgresql

首先安装一些依赖

apt-get update

apt-get install gcc

apt-get install zlib1g-dev

apt-get install g++

apt-get install libxml2

apt-get install libxml2-dev

apt-get install libgdal1-dev

1、安装postgresql

wget http://ftp.postgresql.org/pub/source/v9.1.4/postgresql-9.1.4.tar.gz

mkdir /usr/local/pgsql

tar -zxvf postgresql-9.1.4.tar.gz

cd postgresql-9.1.4

./configure -prefix=/usr/local/pgsql --without-readline

make

make install

 

2、安装geos

mkdir /usr/local/geos

wget http://download.osgeo.org/geos/geos-3.3.5.tar.bz2

tar jxf geos-3.3.5.tar.bz2 

cd geos-3.3.5

./configure -prefix=/usr/local/geos

make

make install

 

3、安装proj4

mkdir /usr/local/proj4

wget http://download.osgeo.org/proj/proj-4.8.0.tar.gz

tar zxf proj-4.8.0.tar.gz

cd proj-4.8.0

./configure -prefix=/usr/local/proj4

make

make install

 

4、安装postgis

mkdir /usr/local/postgis

wget http://postgis.refractions.net/download/postgis-2.0.1.tar.gz

tar zxf postgis-2.0.1.tar.gz

cd postgis-2.0.1

 ./configure -prefix=/usr/local/postgis  --with-pgconfig=/usr/local/pgsql/bin/pg_config  --with-geosconfig=/usr/local/geos/bin/geos-config --with-projdir=/usr/local/proj4

PostGIS is now configured for x86_64-unknown-linux-gnu

 

 -------------- Compiler Info -------------

  C compiler:           gcc -g -O2

  C++ compiler:         g++ -g -O2

  SQL preprocessor:     /usr/bin/cpp -traditional-cpp -P

 

 -------------- Dependencies --------------

  GEOS config:          /usr/local/geos/bin/geos-config

  GEOS version:         3.3.5

  GDAL config:          /usr/bin/gdal-config

  GDAL version:         1.6.3

  PostgreSQL config:    /usr/local/pgsql/bin/pg_config

  PostgreSQL version:   PostgreSQL 9.1.4

  PROJ4 version:        48

  Libxml2 config:       /usr/bin/xml2-config

  Libxml2 version:      2.7.6

  JSON-C support:       yes

  PostGIS debug level:  0

  Perl:                 /usr/bin/perl

 

 --------------- Extensions ---------------

  PostGIS Raster:       enabled

  PostGIS Topology:     enabled

 

 -------- Documentation Generation --------

  xsltproc:            

  xsl style sheets:    

  dblatex:             

  convert:             

  mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

　　

make

make install

5、简单配置

cd /usr/local/pgsql/

 

adduser postgres

mkdir /usr/local/pgsql/data

chown -R postgres /usr/local/pgsql

su postgres

/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

 

启动数据库

/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data

 

 

Success. You can now start the database server using:

 

    /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data

or

    /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l log file start

停止数据库服务

/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data

重新启动数据库

/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data –l pgsql.log

7创建数据库

切换到postgres用户

su postgres

创建数据库gisdb

/usr/local/pgsql/bin/createdb gisdb

增加plpgsql语言

/usr/local/pgsql/bin/createlang plpgsql gisdb

增加动态链接库的搜索路径

vi /etc/ld.so.conf

在最后添加四行：

/usr/local/lib

/usr/local/proj4/lib

/usr/local/geos/lib

/usr/local/pgsql/lib

运行ldconfig命令，使以上修改生效:

/sbin/ldconfig

6、创建数据库

postgres@master:~$ /usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/postgis.sql

/usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/topology.sql 

/usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/rtpostgis.sql

/usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/postgis.sql

/usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/spatial_ref_sys.sql

/usr/local/pgsql/bin/psql -d gisdb -f /usr/local/pgsql/share/contrib/postgis-2.0/legacy.sql 

select postgis_full_version();

 

 

gisdb=# select postgis_full_version();

                                                                         postgis_full_version                                                                          

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

 POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March 2012" GDAL="GDAL 1.6.3, released 2009/11/19" LIBXML="2.7.6" LIBJSON="UNKNOWN" TOPOLOGY RASTER

(1 row)

　　

 

模板：

 /usr/local/pgsql/bin/createdb -T gisdb ysdb

　　

 

 

转载于:https://www.cnblogs.com/1q84/archive/2012/12/17/2821770.html