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 /homewget https://ftp.postgresql.org/pub/source/v10.3/postgresql-10.3.tar.gztar -zxvf postgresql-10.3.tar.gzcd postgresql-10.3./configure \--prefix=/usr/local/postgres/ \--with-ossp-uuid \--with-uuid=ossp \--with-systemd \--with-openssl \makemake install

3. 添加postgres用户并配置数据目录

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

4. 配置启动防火墙

   systemctl start firewalldfirewall-cmd --zone=public --add-port=5432/tcp --permanentfirewall-cmd --reload

5. 修改环境变量

   vim /etc/profileexport PGHOME=/usr/local/postgresexport PGDATA=/data/postgresexport PATH=$PATH:/usr/local/postgres/binESC:wqsource /etc/profile

6. 初始化数据库

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

7. 修改配置

   su postgresvim /data/postgres/pg_hba.conflocal   all             all                                     trusthost    all             all             127.0.0.1/32            trusthost    all             all             0.0.0.0/0               trusthost    all             all             ::1/128                 trustlocal   replication     all                                     trusthost    replication     all             127.0.0.1/32            trusthost    replication     all             0.0.0.0/0               trusthost    replication     all             ::1/128                 trustESC:wqvim /data/postgres/postgresql.conflisten_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. 领支付宝红包支持作者