Feng’ Blog

Deepin安装postgres10
Deepin安装postgres10sudo apt-get -y update # 更新 sudo apt...
扫描右侧二维码阅读全文
04
2019/03

Deepin安装postgres10

Deepin安装postgres10

POSTGRES.png

sudo apt-get -y update   # 更新

sudo apt-get install postgresql-10  # 安装postgres10

启动postgresql

systemctl start  postgresql.service

查看服务运行情况

systemctl status postgresql.service

重置超级管理密码

sudo su - postgres -c psql

postgres=# alter user postgres with password 'new-password';

# 查看用户
\du
# 退出
\q
# 帮助
\?

开启外部访问

sudo find / -name pg_hba.conf
sudo echo "host    odoo    all    0.0.0.0/0    md5" >> /etc/postgresql/10/main/pg_hba.conf
Last modification:March 4th, 2019 at 09:54 pm
If you think my article is useful to you, please feel free to appreciate

Leave a Comment