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
     # 接下来输入密码
     12345678
     # 退出
     \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
    
@耿志环 2012-∞ 冀ICP备17033181号, powered by Gitbook修订: 2019-07-08 16:49:59

results matching ""

    No results matching ""