CentOS7.X安裝postgresql-10.3

PostGreSQL

1. 安裝前的準備

   yum install 
   vim 
   wget 
   firewalld 
   gcc 
   gcc-c++ 
   openssl-devel 
   readline 
   readline-devel 
   zlib 
   zlib-devel 
   uuid-devel 
   systemd-devel 
    -y 

2. 安裝PostGreSQL

   cd /home
   wget https://ftp.postgresql.org/pub/source/v10.3/postgresql-10.3.tar.gz
   tar -zxvf postgresql-10.3.tar.gz
   cd postgresql-10.3
   ./configure 
   --prefix=/usr/local/postgres/ 
   --with-ossp-uuid 
   --with-uuid=ossp 
   --with-systemd 
   --with-openssl 
   
   make
   make install

3. 新增postgres使用者並配置資料目錄

   mkdir /data/
   mkdir /data/postgres/
   
   useradd postgres
   
   chown -R postgres:postgres /data/postgres/
   chown -R postgres:postgres /usr/local/postgres/
   chown -R postgres:postgres /home/postgresql-10.3/

4. 配置啟動防火牆

   systemctl start firewalld
   firewall-cmd --zone=public --add-port=5432/tcp --permanent
   firewall-cmd --reload

5. 修改環境變數

   vim /etc/profile
   
   export PGHOME=/usr/local/postgres
   export PGDATA=/data/postgres
   export PATH=$PATH:/usr/local/postgres/bin
   
   ESC
   :wq
   
   source /etc/profile

6. 初始化資料庫

   su postgres
   /usr/local/postgres/bin/initdb -D /data/postgres

7. 修改配置

   su postgres
   vim /data/postgres/pg_hba.conf
   
   local   all             all                                     trust
   host    all             all             127.0.0.1/32            trust
   host    all             all             0.0.0.0/0               trust
   host    all             all             ::1/128                 trust
   
   local   replication     all                                     trust
   host    replication     all             127.0.0.1/32            trust
   host    replication     all             0.0.0.0/0               trust
   host    replication     all             ::1/128                 trust
   
   ESC
   :wq
   
   vim /data/postgres/postgresql.conf
   
   listen_addresses = `*`
   
   ESC
   :wq

8. 啟動

   su postgres
   /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile start

9. 建立預設資料庫及設定密碼

   su postgres
   /usr/local/postgres/bin/createdb postgres
   /usr/local/postgres/bin/psql postgres
   # 已經進入了postgres控制檯
   password
   # 接下來輸入密碼
   **************
   # 退出
   q

10. 停止、啟動、重啟、過載

    su postgres
    /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile stop
    /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile start
    /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile restart
    /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile reload

11. 領支付寶紅包支援作者