Shulou(Shulou.com)06/01 Report--

Software package download

Wget http://download.osgeo.org/postgis/source/postgis-2.2.2.tar.gz

Wget https://ftp.postgresql.org/pub/source/v9.4.8/postgresql-9.4.8.tar.gz

Wget http://download.osgeo.org/gdal/2.0.0/gdal-2.0.0.tar.gz

Wget http://download.osgeo.org/geos/geos-3.5.0.tar.bz2

Related dependency package installation

# yum install-y gcc gdb strace gcc-c++ autoconf libjpeglibjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-develzlib zlib-devel glibc glibc-devel glib2 glib2-devel bzip2 bzip2-devel

# yum install ncurses ncurses-devel curl curl-devel e2fsprogs patche2fsprogs-devel krb5-devel libidn libidn-devel openldap-devel nss_ldapopenldap-clients openldap-servers libevent-devel libevent uuid-devel uuidmysql-devel

# yum install make cmake lrzsz perl perl-ExtUtils-Embed readlinereadline-devl python-devel proj proj-devel screen gmp gmp-devel mpfr mpfr-develdevtoolset-2-gcc devtoolset-2-binutils devtoolset-2-gcc-c++ boost boost-develcmake3 cmake3-gui cmake3-data

-downloadonly--downloaddir=/mnt/yilaibao-y

Installation and deployment

Postgresql installation

Create a package storage directory:

# mkdir / data

Go to the directory and follow the link above to download the software package

# cd / data

Extract the installation package

# tar zxvf postgresql-9.4.8

# cd postgresql-9.4.8

#. / configure-prefix=/usr/local/pgsql9_4_8-with-python-with-perl

# make

# make install

Add database account

# adduser postgres

Add data storage path

# mkdir-p / usr/local/pgsql9_4_8/data

# chown postgres / usr/local/pgsql9_4_8/data (chown postgres / usr/local chmod 777 / usr/local/pgsql9_4_8/

Chown postgres / usr/local/pgsql9_4_8/bin)

Enter an ordinary account

Su-postgres

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

Start

/ usr/local/pgsql9_4_8/bin/postgres-D / usr/local/pgsql9_4_8/data > logfile 2 > & 1 &

Stop it

Cd / usr/local/pgsql9_4_8/bin/

. / pg_ctl stop-D / usr/local/pgsql9_4_8/data/-m {smart | fast}

Add environment variables under the postgres account

Export LD_LIBRARY_PATH=/usr/local/pgsql9_4_8/lib

Export PATH=/usr/local/pgsql9_4_8/bin:$PATH

-

/ / Note: permanently add method

Access to the general account: su-postgres

# vi ~ / .bash_profile

Export LD_LIBRARY_PATH=/usr/local/pgsql9_4_8/lib

Export PATH=/usr/local/pgsql9_4_8/bin:$PATH

Check the environment variable # echo $PATH

Save the exit so that it can be added permanently.

-

Note that you need to add environment variables again under root. It is best to add the above environment variables under both normal and root accounts.

Quit the ordinary account and install the fuzzystrmatch extension package

Cd contrib

Make

Make install

Install gdal and geos

Cd / data

Tar zxvf gdal-2.0.0.tar.gz

Cd gdal-2.0.0

. / configure-- prefix=/usr/local/gdal-- with-xml2=/usr/bin/xml2-config-- with-static-proj4=/usr/bin/proj (compile and install proj)

Make

Make install

Cd / data

Tar jxvf geos-3.5.0.tar.bz2

Cd geos-3.5.0

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

Make

Make install

Vi / etc/ld.so.conf

/ usr/local/pgsql9_4_8/lib (change according to the path you installed)

/ usr/local/gdal/lib (change according to the path you installed)

/ usr/local/geos3/lib (change according to the path you installed)

/ usr/local/lib

Run # ldconfig as root after the final installation

Postgis installation

# cd / data

# tar zxvfpostgis-2.2.2.tar.gz

# cdpostgis-2.2.2/

. / configure--with-pgconfig=/usr/local/pgsql9_4_8/bin/pg_config--with-gdalconfig=/usr/local/gdal/bin/gdal-config--with-geosconfig=/usr/local/geos3/bin/geos-config

Make

Cd extensions

Cd postgis

Make clean

Make

Make install

Cd..

Cdpostgis_topology

Make clean

Make

Make install

Cd..

Cd postgis_tiger_geocoder

Make clean

Make

Make install

Cd.. /..

Make install

Go to the console and execute the following statement:

CREATE EXTENSIONpostgis

CREATE EXTENSIONfuzzystrmatch

CREATE EXTENSIONpostgis_tiger_geocoder

CREATE EXTENSIONpostgis_topology

Pgrouting installation

Yum-y install bzip2

Cd / data

Tar xvJf CGAL-4.8.1.tar.xz

Cd CGAL-4.8.1

Yum install gmp gmp-devel

Yum install mpfr mpfr-devel

Cmake.

Make

Make install

Wget http://people.centos.org/tru/devtools-2/devtools-2.repo-O/etc/yum.repos.d/devtools-2.repo

Yum install devtoolset-2-gcc devtoolset-2-binutilsdevtoolset-2-gcc-c++

PATH=/opt/rh/devtoolset-2/root/usr/bin/:$PATH

Cd..

Tar zxvf pgrouting-2.2.0.tar.gz

Cd pgrouting-pgrouting-2.2.0/

Mkdir build

Cd build/

Cmake3..

Make

Make install

Su-postgres

Psql

CREATE EXTENSION pgrouting

Set the password for the postgres user:

Alter user postgres with password 'postgres'

Testworthy girls #

Pg database settings remote connection:

1 、 # cd / usr/local/pgsql9_4_8/data

# vi pg_hba.conf

2 、 # vipostgresql.conf

3. Set up the firewall (under root)

# vi / etc/sysconfig/iptables

-An INPUT-m state-- state NEW-m tcp-p tcp-- dport 5432-j ACCEPT

4. Stop and start again (in postgres account)

$pg_ctl stop-D / usr/local/pgsql9_4_8/data/-m fast

$/ usr/local/pgsql9_4_8/bin/postgres-D / usr/local/pgsql9_4_8/data > logfile 2 > & 1 &

Pg Database Settings Boot self-boot:

Set PostgreSQL Boot self-boot

The boot script of PostgreSQL is located in the contrib/start-scripts path of the PostgreSQL source directory.

The linux file is the startup script on the linux system

1) modify linux file attributes and add X attributes

# chmod axix linux

2) copy the linux file to the / etc/init.d directory and rename it to postgresql

# cp linux/etc/init.d/postgresql

3) modify two variables of / etc/init.d/postgresql file

Prefix is set to the installation path of postgresql: / opt/pgsql-9.1.2

Set PGDATA to the data directory path of postgresql:

4) execute service postgresqlstart to start the PostgreSQL service

# service postgresqlstart

5) set the postgresql service to boot automatically

# chkconfig-addpostgresql

By executing the above command, the postgresql service can be booted and started automatically.

Matters needing attention

Before deployment, please check whether the system has installed postgresql, postgis and other above software. if so, please uninstall first. Different Linux distributions may encounter other software dependencies during installation that need to be solved according to the prompts during installation.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.