ubuntu 預設的 postgresql-client 版本為 9.5,但像是 pg_dump 之類的工具就必須完全符合大版本,因此以下安裝教學。

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
RELEASE=$(lsb_release -cs)
echo "deb http://apt.postgresql.org/pub/repos/apt/ ${RELEASE}"-pgdg main | sudo tee  /etc/apt/sources.list.d/pgdg.list
apt update
apt install postgresql-client-10

測試

pg_dump --version