首先 安装postgresql数据库
Create the file /etc/apt/sources.list.d/pgdg.list and add a line for the repository
deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main
Import the repository signing key, and update the package lists
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
apt-get install postgresql-10
The repository contains many different packages including third party addons. The most common and important packages are (substitute the version number as required):
| postgresql-client-10 | client libraries and client binaries |
| postgresql-10 | core database server |
| postgresql-contrib-9.x | additional supplied modules (part of the postgresql-xx package in version 10 and later) |
| libpq-dev | libraries and headers for C language frontend development |
| postgresql-server-dev-10 | libraries and headers for C language backend development |
| pgadmin4 | pgAdmin 4 graphical administration utility |
su postgres
psql
\password
设置密码
\q退出
exit
安装postgis
apt-get install postgis
安装postgis-gui 图形化导入shp文件工具
apt-get install postgis-gui
安装qgis
sudo add-apt-repository ppa:ubuntugis/ubuntugis-unstable
sudo apt-get update
sudo apt-get install qgis