Ubuntu20.04 安装 postgresql13

1、添加存储库

sudo apt update
sudo apt install curl gpg gnupg2 software-properties-common apt-transport-https lsb-release ca-certificates

add the APT repository，importing GPG key

curl -fsSL https://www.postgresql.org/media/keys/ACCC4CF8.asc|sudo gpg --dearmor -o /etc/apt/trusted.gpg.d/postgresql.gpg

add repository contents

echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list

2、安装

sudo apt update

sudo apt install postgresql-13 postgresql-client-13

systemctl status postgresql@13-main.service

3、配置远程连接

编辑文件 sudo vi /etc/postgresql/13/main/postgresql.conf

# Listen on all interfaces
listen_addresses = '*'

# Listen on specified private IP address
listen_addresses = '192.168.10.11'

编辑文件 sudo vi /etc/postgresql/13/main/pg_hba.conf

# Accept from anywhere
host    all             all             0.0.0.0/0               trust
host all all 0.0.0.0/0 md5

# postgres用户通过密码登录
host all postgres  trust

# Accept from trusted subnet
host all all 10.10.10.0/24 md5

重启

sudo systemctl restart postgresql

4、修改默认postgres用户的密码

# 进入psql
sudo -u postgres psql

修改密码
\password postgres  并输入密码123456