postgresql mogo資料庫允許其它主機訪問

標籤：sql   str   admin   cal   color   listen   art   main   訪問   

postgres:

/etc/postgresql/9.5/main/

environment  pg_ctl.conf  pg_hba.conf  pg_ident.conf  postgresql.conf  start.conf

postgresql.conf 修改：

listen_addresses = ‘*‘ #listen_addresses = ‘localhost‘ # what IP address(es) to listen on;# comma-separated list of addresses;# defaults to ‘localhost‘; use ‘*‘ for all# (change requires restart)

pg_hba.conf修改：

# Database administrative login by Unix domain socketlocal   all             postgres                                peer# TYPE  DATABASE        USER            ADDRESS                 METHOD# "local" is for Unix domain socket connections onlylocal   all             all                                     peer# IPv4 local connections:host    all             all             127.0.0.1/32            md5# IPv6 local connections:host    all             all             ::1/128                 md5# dyhost    all             all             172.18.1.80/32          md5# acmhost    all             all             172.22.27.0/8           md5

 

mongo:

 修改/etc/mongod.conf

bindIp: [127.0.0.1,192.168.1.2,192.168.1.3,192.168.1.4,192.168.1.5]

postgresql mogo資料庫允許其它主機訪問