当 OE 跟 postgesql 不在一个机器上
-
一直以来玩oe ， oe 跟 postgesql 一直在一个机器上。
默认方式下，只允许本地登录，甚至不要设置密码，简单又方便，还够安全
直到昨天， 想分开安装在 两个机器上， 才发现自己不会玩，又折腾一宿 失败了
早上群里 请教了几位在 buke，amos，jeff 的帮助下
似乎走通， 先记下，避免忘记
1. 修改 绑定到对外的 ip
修改 postgres.conf ， list_address = ‘*’
2. 防火墙，打开 5432 端口，重启
3. pg_hba.conf
允许 访问的 ip 和 登录的方式
host all all 192.168.2.12/32 trust
允许 192.168.2.12 访问 ， trust 是不要密码 ，应 改成 md5
重启 postgresql
4 查看 postgres 绑定的 ip
netstat -apn | grep 5432 -
不错的体验 mark
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login