源码安装PG16.2

郑全

1.建立用户
   -- 创建用户
groupadd postgres
useradd -g postgres postgres
echo "postgres" | passwd --stdin postgres

2. 创建目录
mkdir -p /u01/postgresql/{pgdata,archive,scripts,backup,pg16,soft}
chown -R postgres:postgres /u01/postgresql
chmod -R 775 /u01/postgresql

3.依赖包安装
  yum install -y cmake make gcc zlib zlib-devel gcc-c++ perl readline readline-devel  \
python36 tcl openssl ncurses-devel openldap pam flex libicu-devel

4.下载软件源
  cd /u01/postgresql/soft
  wget https://ftp.postgresql.org/pub/s ... tgresql-16.2.tar.gz

5.配置环境变量
cat >>  ~/.bash_profile <<"EOF"
export PGPORT=5432
export PGDATA=/u01/postgresql/pgdata
export PGHOME=/u01/postgresql/pg16
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH
export PATH=$PGHOME/bin:$PATH:.
export PGHOST=$PGDATA
export PGUSER=postgres
export PGDATABASE=postgres
export PGCLIENTENCODING=GBK
EOF


6.支持中文
   修改/etc/locale.conf配置

  原配置：    LANG="en_US.UTF-8"
  修改为：    LANG="zh_CN.UTF-8"
  输入：      source /etc/locale.conf

7.配置
  -- 配置
  su - postgres
  cd /u01/postgresql/soft
  tar zxvf postgresql-16.2.tar.gz
  cd postgresql-16.2
  ./configure --prefix=/u01/postgresql/pg16

8.编译安装
  $ make world -j 16 && make install-world

9.初始化
   su - postgres
   export LANG=zh_CN.gbk
   /u01/postgresql/pg16/bin/initdb -D /u01/postgresql/pgdata -E UTF8 --locale=zh_CN.UTF8 -U postgres


10.修改数据库参数
cat >> /u01/postgresql/pgdata/postgresql.conf << "EOF"
listen_addresses = '*'
port=5432
unix_socket_directories='/u01/postgresql/pgdata'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%a.log'
log_truncate_on_rotation = on
max_connections = 500
shared_buffers = 16GB
EOF

11.允许客户端访问
   cat >> /u01/postgresql/pgdata/pg_hba.conf << "EOF"
# TYPE  DATABASE    USER    ADDRESS       METHOD
host      all       all    0.0.0.0/0        md5
EOF

12.设置系统服务
  -- 配置系统服务
  $ su -
cat > /etc/systemd/system/PG16.service <<"EOF"
[Unit]
Description=PostgreSQL database server
Documentation=man:postgres(1)
After=network.target

[Service]
Type=forking
User=postgres
Group=postgres
Environment=PGPORT=5432
Environment=PGDATA=/u01/postgresql/pgdata
OOMScoreAdjust=-1000
ExecStart=/u01/postgresql/pg16/bin/pg_ctl start -D ${PGDATA} -s -o "-p ${PGPORT}" -w -t 300
ExecStop=/u01/postgresql/pg16/bin/pg_ctl stop -D ${PGDATA} -s -m fast
ExecReload=/u01/postgresql/pg16/bin/pg_ctl reload -D ${PGDATA} -s
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=0

[Install]
WantedBy=multi-user.target
EOF

13.配置自动启动
   systemctl daemon-reload
   systemctl enable PG16
   systemctl start PG16
   systemctl status PG16


14.修改POSTGRES密码
   su - postgres
   psql
   \password postgres
   or:
   alter user postgres with password 'postgres';

到此，安装到此全部完成。