Postgre和拓展PostGIS 搭建和配置

目录：

1. 搭建过程
2. 安装PostGIS

搭建过程

1. 安装PG

   [root@localhost ~]# yum install readline* -y
   [root@localhost ~]# wget https://ftp.postgresql.org/pub/source/v9.5.1/postgresql-9.5.1.tar.gz
   [root@localhost ~]# tar xvf postgresql-9.5.1.tar.gz
   [root@localhost ~]# cd postgresql-9.5.1/
   [root@localhost postgresql-9.5.1]# ./configure --prefix=/usr/local/pgsql --without-zlib
   [root@localhost postgresql-9.5.1]# make world && make install-world 
   

2. 创建用户及用户组

   [root@localhost postgresql-9.5.1]# groupadd -g 101 dba
   [root@localhost postgresql-9.5.1]# useradd -u 516 -g dba -G root -d /usr/local/pgsql postgres
   [root@localhost postgresql-9.5.1]# id postgres
   uid=516(postgres) gid=101(dba) groups=101(dba),0(root)
   [root@localhost postgresql-9.5.1]# passwd postgres
   

3. 配置.bash_profile

   [root@localhost ~]# cp /etc/skel/.* /usr/local/pgsql/
   [root@localhost skel]# cd /usr/local/pgsql/
   
   [root@localhost pgsql]# vim .bash_profile 
   # .bash_profile
   
   # Get the aliases and functions
   if [ -f ~/.bashrc ]; then
           . ~/.bashrc
   fi
   
   # User specific environment and startup programs
   
   PATH=$PATH:$HOME/bin
   
   export PGHOME=/usr/local/pgsql
   
   export PGDATA=/usr/local/pgsql/data
   
   export PATH=$PATH:/usr/local/pgsql/bin
   
   #stty erase ^H
   set umask to 022
   umask 022
   PS1