目录
pg安装
安装命令指导
https://www.postgresql.org/download/linux/redhat/
# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Install PostgreSQL:
sudo yum install -y postgresql12-server
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12
执行安装命令
$ 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 postgresql12-server
$ mkdir -p /home/module/pg/data
$ userdel postgres
$ useradd postgres
$ chown postgres:root /home/module/pg/data
$ chown postgres:root /home/module/pg/logs
初始化pg
$ su - postgres
$ /usr/pgsql-12/bin/initdb -D /home/module/pg/data
修改配置文件
$ su - root
$ vim /usr/lib/systemd/system/postgresql-12.service
Environment=PGDATA=/home/module/pg/data
$ su - postgres
$ vim /home/module/pg/data/postgresql.conf
listen_addresses = '*'
$ vim /home/module/pg/data/pg_hba.conf
host all all 0.0.0.0/0 password
修改pg用户密码
$ psql -d postgres -U postgres
$ \password
启动pg
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12
安装pgadmin
yum命令安装
$ sudo yum install -y yum-utils device-mapper-persistent-data lvm2
$ sudo yum-config-manager --add-repo https://mirrors.aliyun.com/docker-ce/linux/centos/docker-ce.repo
$ sudo yum install docker-ce.x86_64
$ sudo systemctl enable docker
$ sudo systemctl start docker
$ docker pull dpage/pgadmin4
$ docker run -d -p 5433:80 --restart always --name pgadmin4 -e PGADMIN_DEFAULT_EMAIL=admin@admin.com -e PGADMIN_DEFAULT_PASSWORD=postgres dpage/pgadmin4
网络配置
firewall设置
https://www.cnblogs.com/straycats/p/10714257.html
firewall-cmd --zone=public --add-rich-rule='rule family="ipv4" source address="192.168.0.0/24" accept'
firewall-cmd --zone=public --add-rich-rule='rule family="ipv4" source address="192.168.10.0/24" port port=22 protocol=tcp reject'
firewall-cmd --zone=public --remove-rich-rule='rule family="ipv4" source address="192.168.0.0/24" accept'
插件支持
安装postgis
安装工具包
$ yum install wget net-tools epel-release -y
安装postgis
$ yum install postgis30_12 postgis30_10-client -y
安装拓展工具
$ yum install ogr_fdw12 -y
$ yum install pgrouting_12 -y
Postgres数据库下执行语句
create extension fuzzystrmatch;
create extension postgis;
create extension postgis_tiger_geocoder;
create extension postgis_topology;
支持uuid_generate_v4
create extension pgcrypto;
create extension "uuid-ossp";
select uuid_generate_v4();
创建表空间
创建目录
$ su - root
$ mkdir -p /home/pgdata/namespace/tbs_gcgl
$ chown postgres:root /home/pgdata/namespace/tbs_gcgl
pgadmin界面创建表空间
pgadmin界面创建表空间