postgresql
https://www.postgresql.org/download/linux/ubuntu/
- 更新软件包
sudo apt update
- 查看postgresql软件包版本
apt list postgresql*
- 安装postgresql10
sudo apt-get install postgresql-10
- 配置postgresql.conf
vi /etc/postgresql/10/main/postgresql.conf
将 #listen_addresses = 'localhost' 的注释去掉并改为 listen_addresses = '*'
- 配置pg_hba.conf
vi /etc/postgresql/10/main/pg_hba.conf
# IPv4 local connections:
host all all 192.168.244.61/32 trust
- 重启数据库
/etc/init.d/postgresql restart
- 连接数据库
psql -U postgres -p 5432 -h 192.168.244.xxx