https://www.postgresql.org/download/linux/ubuntu/
1 check Xenial16.04
2 建立檔案 /etc/apt/sources.list.d/pgdg.list
新增 deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main
3 新增key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
4 update
sudo apt-get update
5 install
sudo apt-get install postgresql-9.6
6 connect to postgresql
sudo su - postgres
psql
7 檢視登入使用者資訊
postgres-# \conninfo
8退出
postgres-# \q