Ubuntu18安装postgresql-10
最近切换Ubuntu作为办公系统,所有软件安装都要重来一遍。
官方文档: https://www.postgresql.org/download/linux/ubuntu/
查看系统版本
~ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 18.04.2 LTS Release: 18.04 Codename: bionic我的系统是 bionic, 其他还有xenial(16), trusty(14).
创建resource源
vim /etc/apt/sources.list.d/pgdg.list deb bionic-pgdg main导入key
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add - sudo apt-get update可以安装以下软件
| name | desc |
| ---- | ----|
|postgresql-client-10 | client libraries and client binaries |
|postgresql-10 | core database server |
|postgresql-contrib-9.x | additional supplied modules (part of the postgresql-xx package in version 10 and later) |
|libpq-dev | libraries and headers for C language frontend development |
|postgresql-server-dev-10| libraries and headers for C language backend development |
|pgadmin4 | pgAdmin 4 graphical administration utility |
安装
sudo apt-get install postgresql-10 pgadmin4 安装之后安装完毕已经启动,可以修改下密码:
sudo su postgres ALTER USER postgres WITH PASSWORD '新密码';安装完的目录: /var/lib/postgresql/10
然后其他配置类似centos7: https://www.cnblogs.com/woshimrf/p/centos-install-postgresql.html
启动pgadminUbuntu上navicate貌似不好装,使用官方pgadmin4
sudo find / -name pgAdmin4 ## 启动 pgAdmin4