目录

pg安装

安装命令指导

执行安装命令

初始化pg

修改配置文件

修改pg用户密码

启动pg

安装pgadmin

yum命令安装

网络配置

firewall设置

插件支持

安装postgis

创建表空间

pgadmin界面创建表空间

pg导入导出

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界面创建表空间

 

pg导入导出