centos8.5 直接安装pgsql 14

安装部署

sudo dnf update
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo dnf -qy module disable postgresql
sudo dnf install -y postgresql14-server
#初始化
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl start postgresql-14

#修改数据库路径
sudo systemctl stop postgresql-14
sudo mv /var/lib/pgsql/14/data /data/pgsql
sudo ln -s /data/pgsql /var/lib/pgsql/14/data

#服务器IP绑定
#vi /data/pgsql/postgresql.conf 
sed -i "s/#listen_addresses = 'localhost'/listen_addresses = '*'/g" /data/pgsql/postgresql.conf 

#IP访问限制
#vi /data/pg_hba.conf
echo "host    all             all             192.168.1.0/24        md5" >> /data/pgsql/pg_hba.conf

#重新启动服务
sudo systemctl start postgresql-14
sudo systemctl enable postgresql-14
systemctl status postgresql-14

#密码修改
sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'new_password';"

#防火墙
systemctl stop firewalld &&  systemctl disable firewalld

#常用命令
echo "sudo -u postgres pg_dump -U postgres -d $1 -f $1.sql" > /data/pgsql/backup/export.sh 
echo "sudo -u postgres psql -U postgres -d xxx_data < $1" > /data/pgsql/backup/inport.sh 
echo "sudo -u postgres psql -d xx_data" > /data/ssh/pgsql.sh 

参考地址