centos环境+pgsql+postgis+apache+php等插件的安装

1、centos系统的安装

http://www.linuxidc.com/Linux/2014-02/97389.htm

 

只作为服务器的话，选Minimal

 

2、pgsql的安装

http://my.oschina.net/tashi/blog/189351

 

3、postgis的安装

安装geos时出现“line 990: g++: command not found”错误

解决方法：

[root@cqs geos-3.4.2]# yum -y groupinstall 'Development Tools'

安装postgis时先安装

gdal-1.11.2、geos-3.4.2、ibxml2-2.9.2、proj-4.9.1、json-c-0.12

 

最后安装postgis时，先进行配置

[root@cqs postgis-2.1.6]# ./configure --prefix=/usr/local/postgis-2.1.6 --with-pgconfig=/usr/local/postgresql-9.5/bin/pg_config  --with-gdalconfig=/usr/local/gdal-1.11.2/bin/gdal-config  --with-geosconfig=/usr/local/geos-3.4.2/bin/geos-config --with-xml2config=/usr/local/libxml2-2.9.2/bin/xml2-config --with-projdir=/usr/local/proj-4.9.1/ --with-jsondir=/usr/local/json-c-0.12/

 

 

 

4、配置运行环境变量--管理上更方便

[root@testbin]# vim /etc/profile

PGDATA=/home/postgres/data

PGHOST=127.0.0.1

PGDATABASE=postgres

PGUSER=postgres

PGPORT=5432

PATH=/usr/local/pgsql/bin:$PATH

export PATH USER LOGNAME MAIL HOSTNAME HISTSIZE HISTCONTROL

export PGDATA PGHOST PGDATABASE PGUSER PGPORT

环境变量生效

[root@testbin]# cd  /etc/

[root@testbin]#source profile

配置密码文件--用于管理员无密码连接使用

[root@test ld.so.conf.d]# cd /home/postgres/

[root@test postgres]# cat .pgpass

127.0.0.1:5432:*:postgres:000

WARNING: password file "/home/postgres/.pgpass" has group or world access; permissions should be u=rw (0600) or less

解决方案：

[root@cqs postgres]# ls -la .pgpass

-rw-r--r--. 1 root root 30 9月  15 19:00 .pgpass

[root@cqs postgres]# chmod 600 .pgpass

[root@cqs postgres]# ls -la .pgpass   

-rw-------. 1 root root 30 9月  15 19:00 .pgpass

[root@cqs postgres]#

 

问题：

[postgres@cqs data]$ psql -h 127.0.0.1 -U pgb_user -d read_db -p 5433

psql: ERROR:  pgbouncer cannot connect to server

解决方案：

[postgres@cqs data]$ vim postgresql.conf

listen_addresses = '*'

[postgres@cqs data]$ vim pg_hba.conf

# IPv4 local connections:

host    all             all             127.0.0.1/32            trust

host    all             all              0.0.0.0/0              md5

[postgres@cqs local]$ cd /home/postgres/data/

[postgres@cqs data]$ pg_ctl restart -D ./

[postgres@cqs pgbouncer]$ /usr/local/pgbouncer-1.5.4/bin/pgbouncer  -R -d /home/postgres/pgbouncer/pgbouncer.ini

 

5、apache与php的安装

（1）apache的安装

    cd /home/cqs/source/

tar xf httpd-2.3.16-beta.tar.bz2

cd httpd-2.3.16-beta

./configure --prefix=/usr/local/httpd --enable-so

报错：解决方案 http://cuisuqiang.iteye.com/blog/2068794

安装对应的wget查找命令yum install wget -y

安装apr :

wget http://archive.apache.org/dist/apr/apr-1.4.5.tar.gz

cd /home/cqs/source/

tar -zxf apr-1.4.5.tar.gz

cd apr-1.4.5

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

make

make install

安装apr-util和pcre-8.10.zip

wget http://archive.apache.org/dist/apr/apr-util-1.3.12.tar.gz

wget http://jaist.dl.sourceforge.net/project/pcre/pcre/8.10/pcre-8.10.zip

tar -zxf apr-util-1.3.12.tar.gz

cd apr-util-1.3.12

./configure --prefix=/usr/local/apr-util -with-apr=/usr/local/apr/bin/apr-1-config

make

make install

cd ..

cd httpd-2.3.16-beta

./configure --prefix=/usr/local/httpd --enable-so --with-apr=/usr/local/apr --with-apr-util=/usr/local/apr-util/ --with-pcre=/usr/local/pcre

make

make install

/usr/local/httpd/bin/apachectl start --启动apache服务

/usr/local/httpd/bin/apachectl restart --重启apache服务

/usr/local/httpd/bin/apachectl stop --停止apache服务

（2）freetype的安装

cd /home/cqs/source/

tar xf freetype-2.4.0.tar.bz2

cd freetype-2.4.0

cd builds/unix/

./configure --prefix=/usr/local/freetype --enable-shared

make

make install

（3）freetds的安装

cd /home/cqs/source/

tar -zxvf freetds-current.tar.gz

cd freetds-dev.0.99.523/

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

gmake

gmake install

（4）php的安装

cd /home/cqs/source/

tar xf php-7.0.1.tar.bz2

cd php-7.0.1

yum install libxml2

yum install libxml2-devel

yum install libpng-devel

 ./configure --prefix=/usr/local/php -with-pgsql=/usr/local/postgresql-9.5 --with-gd --enable-gd-native-ttf --with-freetype-dir=/usr/local/freetype --with-zlib

gmake

gmake install

安装完毕后，跟apache通讯时发现少了libphp7.so文件，解决方案是编译时加上--with-apxs2=/usr/local/apache/bin/apxs

所以编译时要的语句是

./configure --prefix=/usr/local/php -with-pgsql=/usr/local/postgresql-9.5 --with-gd --enable-gd-native-ttf --with-freetype-dir=/usr/local/freetype --with-zlib --with-apxs2=/usr/local/apache/bin/apxs