Toggle navigation
Home
安装部署
Archives
Tags
Postgresql安装配置
数据库
环境搭建
2019-05-06 06:51:53
110
0
0
louyj
数据库
环境搭建
## 安装postgresql sudo yum install postgresql-server postgresql ## 验证是否安装成功 sudo rpm -aq| grep postgres ## 初始化数据库 #/var/lib/pgsql/data service postgresql initdb ## 启动服务并设置为开机启动 service postgresql start chkconfig postgresql on ## 设置postgres用户密码 su - postgres psql \password postgres xxxpgxxx ## 开启远程访问 vi /var/lib/pgsql/data/postgresql.conf --- listen_addresses ='*' ------------------------------------ vi /var/lib/pgsql/data/pg_hba.conf -- host all all 0.0.0.0/0 md5 重启服务 service postgresql restart ## 配置web(pgweb)界面 wget wget https://github.com/sosedoff/pgweb/releases/download/v0.9.2/pgweb_linux_amd64.zip unzip pgweb_linux_amd64.zip ./pgweb_linux_amd64 --bind xxx http://xxx:8081/
Pre:
NTP时间同步
Next:
Install Docker
0
likes
110
Weibo
Wechat
Tencent Weibo
QQ Zone
RenRen
Submit
Sign in
to leave a comment.
No Leanote account?
Sign up now.
0
comments
More...
Table of content
louyj
No Leanote account? Sign up now.