linux32安装pgsql,Linux安装pgsql

作者QQ：67065435 QQ群：821635552

安装前的准备 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

# 接下来输入密码

12345678

# 退出

\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