# 配置1echo"listen_addresses = '*'">> /var/lib/pgsql/14/data/postgresql.conf
# 关闭sed-i"/^listen_addresses = '*'$/c#listen_addresses = '*'" /var/lib/pgsql/14/data/postgresql.conf
# 开启sed-i"/^#listen_addresses = '*'$/clisten_addresses = '*'" /var/lib/pgsql/14/data/postgresql.conf
# 配置2
安装
echo"host all all all md5">> /var/lib/pgsql/14/data/pg_hba.conf
开启
sed-i'/#host all all all md5/chost all all all md5' /var/lib/pgsql/14/data/pg_hba.conf
关闭
sed-i'/host all all all md5/c#host all all all md5' /var/lib/pgsql/14/data/pg_hba.conf
在线安装脚本
cat<<EOF|tee /root/init.sh
sudo systemctl stop firewalld
mkdir -p /root/postgres
sed -i '/^keepcache=0/ckeepcache=1' /etc/yum.conf
sed -i '/^cachedir=/ccachedir=/root/postgres' /etc/yum.conf
sudo yum install -y vim tree
sudo yum install -y gcc make subversion gcc-c++ sqlite-devel libxml2 libxml2-devel python-devel numpy swig expat-devel libcurl-devel
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgresql14-server
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
sudo yum install -y wget net-tools epel-release
sudo yum install -y postgis32_14.x86_64
# 开启访问权限
echo "listen_addresses = '*'" >> /var/lib/pgsql/14/data/postgresql.conf
sed -i '/local all all peer/clocal all all trust' /var/lib/pgsql/14/data/pg_hba.conf
sed -i '/host all all 127.0.0.1\/32 scram-sha-256/chost all all 127.0.0.1/32 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed -i '/host all all ::1\/128 scram-sha-256/chost all all ::1/128 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed -i '/local replication all peer/clocal replication all trust' /var/lib/pgsql/14/data/pg_hba.conf
sed -i '/host replication all 127.0.0.1\/32 scram-sha-256/chost replication all 127.0.0.1/32 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed -i '/host replication all ::1\/128 scram-sha-256/chost replication all ::1/128 trust' /var/lib/pgsql/14/data/pg_hba.conf
echo "host all all all md5" >> /var/lib/pgsql/14/data/pg_hba.conf
# 重启
sudo systemctl restart postgresql-14
sudo /usr/pgsql-14/bin/psql -U postgres -c "ALTER USER postgres WITH PASSWORD '@123++';"
sudo /usr/pgsql-14/bin/psql -U postgres -c 'CREATE EXTENSION postgis;'
sudo /usr/pgsql-14/bin/psql -U postgres -c 'CREATE EXTENSION postgis_topology;'
sudo /usr/pgsql-14/bin/psql -U postgres -c "CREATE EXTENSION \"uuid-ossp\";"
sudo systemctl restart postgresql-14
EOFchmod +x /root/init.sh
离线安装软件
离线机器
#/var/lib/pgsqlcurrent_path=$(cd$(dirname $0);pwd)# 解压tar-zxvf postgres.tar.gz
# 初始化repocat<<EOF|tee /etc/yum.repos.d/local-postgres.repo
[Postgres]
name=Postgres
baseurl=file://${current_path}/postgres/
enabled=1
gpgcheck=0
priority=1
EOFmv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak
# 安装sudo yum install-yvim tree wget net-tools
sudo yum install-y gcc make subversion gcc-c++ sqlite-devel libxml2 libxml2-devel python-devel numpy swig expat-devel libcurl-devel
sudo yum install-y epel-release
sudo yum install-y postgresql14-server
sudo yum install-y postgis32_14.x86_64
# 新建数据目录mkdir-p /var/lib/pgsql/14/data
chown-R postgres:postgres /var/lib/pgsql
# 初始化数据库sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
# 启动sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
# 开启访问权限echo"listen_addresses = '*'">> /var/lib/pgsql/14/data/postgresql.conf
sed-i'/local all all peer/clocal all all trust' /var/lib/pgsql/14/data/pg_hba.conf
sed-i'/host all all 127.0.0.1\/32 scram-sha-256/chost all all 127.0.0.1/32 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed-i'/host all all ::1\/128 scram-sha-256/chost all all ::1/128 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed-i'/local replication all peer/clocal replication all trust' /var/lib/pgsql/14/data/pg_hba.conf
sed-i'/host replication all 127.0.0.1\/32 scram-sha-256/chost replication all 127.0.0.1/32 trust' /var/lib/pgsql/14/data/pg_hba.conf
sed-i'/host replication all ::1\/128 scram-sha-256/chost replication all ::1/128 trust' /var/lib/pgsql/14/data/pg_hba.conf
echo"host all all all md5">> /var/lib/pgsql/14/data/pg_hba.conf
# 重启sudo systemctl restart postgresql-14
# 设置密码sudo /usr/pgsql-14/bin/psql -U postgres -c"ALTER USER postgres WITH PASSWORD '123++';"sudo /usr/pgsql-14/bin/psql -U postgres -c'CREATE EXTENSION postgis;'sudo /usr/pgsql-14/bin/psql -U postgres -c'CREATE EXTENSION postgis_topology;'sudo /usr/pgsql-14/bin/psql -U postgres -c"CREATE EXTENSION \"uuid-ossp\";"# 重启sudo systemctl restart postgresql-14
# 恢复repomv /etc/yum.repos.d/CentOS-Base.repo.bak /etc/yum.repos.d/CentOS-Base.repo