Postgresql安装配置 2019-05-06 14:51:53 数据库 环境搭建 Views:151 Likes:0 Comments:0 ## 安装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/ Loading article… Previous NTP时间同步 Next Install Docker 0 likes 151 views Weibo WeChat Tencent Weibo QQ Zone RenRen Submit Sign in to leave a comment. No Leanote account? Sign up now. 0 comments More comments
No Leanote account? Sign up now.