ubantu-18.04安装PostgreSQL（在线安装）

安装Postgresql 

sudo apt-get install postgresql

遇到问题：E: Package 'postgresql' has no installation candidate

解决办法：更换源。

#  阿里镜像源

deb http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic main restricted universe multiverse

deb http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-security main restricted universe multiverse

deb http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-updates main restricted universe multiverse

deb http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-proposed main restricted universe multiverse

deb http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse
deb-src http://mirrors.aliyun.com/ubuntu/ bionic-backports main restricted universe multiverse

更换源之前先备份源，防止意外发生。

sudo cp /etc/apt/sources.list /etc/apt/sources.list.backup 

编辑源，全部删除更换

sudo gedit /etc/apt/sources.list

更新源：

sudo apt-get update && sudo apt-get upgrade

sudo apt-get install postgresql

apt-get install

切换pgsql账号【root模式下】

# 进入postgresl
psql 

# 显示当前数据库
\l

安装pgAdmin4:

# 需要root权限
su root

# 安装curl
sudo snap install curl

# 添加pgAdmin4源及公钥
curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add

sudo sh -c 'echo "deb https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/$(lsb_release -cs) pgadmin4 main" > /etc/apt/sources.list.d/pgadmin4.list && apt update'

# 安装pgAdmin4（它会提示你Y/N，输入y就可以了，安装挺多东西，时间有点久）
# 方案1：此方式是desktop跟web都安装了
sudo apt install pgadmin4
# 方案2：仅在桌面模式下安装：
sudo apt install pgadmin4-desktop
# 方案3：只为网页模式安装：
sudo apt install pgadmin4-web

# 运行pgAdmin4下的web安装脚本（它会要求填写你的邮箱及密码，仅桌面模式就跳过这行命令）
sudo /usr/pgadmin4/bin/setup-web.sh

# 浏览器访问，输入刚刚的邮箱密码即可登录。
http://你的ip地址/pgadmin4

# 连接输入127.0.0.1，用户postgres 密码：自己的密码