postgresql11-15和postgis30_11的rpm

rpm -ivh postgresql11-libs-11.15-1PGDG.rhel7.x86_64.rpm rpm -ivh postgresql11-11.15-1PGDG.rhel7.x86_64.rpm rpm -ivh postgresql11-server-11.15-1PGDG.rhel7.x86_64.rpm rpm -ivh postgresql11-contrib-11.15-1PGDG.rhel7.x86_64.rpm /usr/pgsql-11/bin/postgresql-11-setup initdb sudo systemctl enable postgresql-11 sudo systemctl start postgresql-11 修改配置 远程连接 /var/lib/pgsql/11/data/ postgresql.conf 第59行取消注释，更改为：listen_addresses = '*' ipv4配置 /var/lib/pgsql/11/data/pg_hba.conf host all all 0.0.0.0/0 md5 修改密码: sudo -u postgres psql alter user postgres with password 'postgres'; \q 安装postgis 67个rpm rpm -ivh *.rpm --nodeps --force create extension postgis; create extension postgis_topology; create extension fuzzystrmatch; create extension postgis_tiger_geocoder;