我的个人网站
PostGreSQL
-
安装前的准备
yum install \ vim \ wget \ firewalld \ gcc \ gcc-c++ \ openssl-devel \ readline \ readline-devel \ zlib \ zlib-devel \ uuid-devel \ systemd-devel \ -y \ -
安装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 -
添加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/ -
配置启动防火墙
systemctl start firewalld firewall-cmd --zone=public --add-port=5432/tcp --permanent firewall-cmd --reload -
修改环境变量
vim /etc/profile export PGHOME=/usr/local/postgres export PGDATA=/data/postgres export PATH=$PATH:/usr/local/postgres/bin ESC :wq source /etc/profile -
初始化数据库
su postgres /usr/local/postgres/bin/initdb -D /data/postgres -
修改配置
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 -
启动
su postgres /usr/local/postgres/bin/pg_ctl -D /data/postgres -l logfile start -
创建默认数据库及设置密码
su postgres /usr/local/postgres/bin/createdb postgres /usr/local/postgres/bin/psql postgres # 已经进入了postgres控制台 \password # 接下来输入密码 ************** # 退出 \q -
停止、启动、重启、重载
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 - 领支付宝红包支持作者
