CentOS7安装PostgreSQL_centos7在线安装postgresql

CentOS7安装PostgreSQL

1. 安装前的准备

   yum -y \
   install \
   openssl-devel \
   readline \
   readline-devel \
   zlib \
   zlib-devel \
   uuid-devel \
   systemd-devel
   1
   2
   3
   4
   5
   6
   7
   8
   9

2. 安装PostGreSQL

   cd /home
   wget --no-check-certificate -c https://ftp.postgresql.org/pub/source/v10.3/postgresql-10.3.tar.gz
   tar -xf 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
   1
   2
   3
   4
   5
   6
   7
   8
   9
   10
   11
   12
   13

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/
   1
   2
   3
   4
   5
   6
   7
   8

4. 配置启动防火墙

   systemctl unmask firewalld
   systemctl enable firewalld
   systemctl start firewalld
   firewall-cmd --permanent --zone=public --add-port=5432/tcp
   firewall-cmd --reload
   1
   2
   3
   4
   5

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
   1
   2
   3
   4
   5
   6
   7
   8
   9
   10

6. 初始化数据库

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

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
   1
   2
   3
   4
   5
   6
   7
   8
   9
   10
   11
   12
   13
   14
   15
   16
   17
   18
   19
   20
   21
   22

8. 启动

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

9. 创建默认数据库及设置密码

   su postgres
   /usr/local/postgres/bin/createdb postgres
   /usr/local/postgres/bin/psql postgres
   # 已经进入了postgres控制台
   \password
   # 接下来输入密码
   **************
   # 退出
   \q
   1
   2
   3
   4
   5
   6
   7
   8
   9

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
    1
    2
    3
    4
    5