ããå®è£
PostgreSQLæ°æ®åºä¹åï¼é»è®¤æ¯åªæ¥åæ¬å°è®¿é®è¿æ¥ãå¦ææ³å¨å
¶ä»ä¸»æºä¸è®¿é®PostgreSQLæ°æ®åºæå¡å¨ï¼å°±éè¦è¿è¡ç¸ åºçé
ç½®ãé
ç½®è¿ç¨è¿æ¥PostgreSQLæ°æ®åºçæ¥éª¤å¾ç®åï¼åªéè¦ä¿®æ¹dataç®å½ä¸çpg_hba.confåpostgresql.conf, å
¶ä¸pg_hba.confæ¯ç¨æ¥é
置对æ°æ®åºç访é®æéï¼postgresql.confæ件ç¨æ¥é
ç½®PostgreSQLæ°æ®åºæå¡å¨çç¸åºçåæ°ã ä¸é¢ä»ç»é
ç½®çæ¥éª¤ï¼
ãã1.ä¿®æ¹pg_hba.confæ件ï¼é
ç½®ç¨æ·ç访é®æéï¼
ãã# TYPE DATABASE USER CIDR-ADDRESS METHOD
ãã# "local" is for Unix domain socket connections only
ããlocal all all trust
ãã# IPv4 local connections:
ããhost all all 127.0.0.1/32 trust
ããhost all all 192.168.1.0/24 md5
ãã# IPv6 local connections:
ããhost all all ::1/128 trust
ããå
¶ä¸çº¢è²æ è¯çå
容为æ°æ·»å çå
容ï¼è¡¨ç¤ºå
许ç½æ®µ192.168.1.0ä¸çææ主æºä½¿ç¨ææåæ³çæ°æ®åºç¨æ·å访é®æ°æ®åºï¼å¹¶æä¾å å¯çå¯ç éª è¯ãå¨æ们çç¯å¢ä¸ï¼æ们éè¦å¨ä¸»æº192.168.1.5ä¸ä½¿ç¨postgresç¨æ·è®¿é®192.168.1.9ä¸çPostgreSQLæ°æ®åºã
ãã2.ä¿®æ¹postgresql.confæ件ï¼å°æ°æ®åºæå¡å¨ççå¬æ¨¡å¼ä¿®æ¹ä¸ºçå¬ææ主æºååºçè¿æ¥è¯·æ±ã
ããå®ä½å°#listen_addresses='localhost'ãPostgreSQLå®è£
å®æåï¼é»è®¤æ¯åªæ¥åæ¥å¨æ¬æºlocalhostçè¿æ¥è¯· æ±ï¼éè¿å°æ¹è¡å
容修æ¹ä¸ºlisten_addresses='*'æ¥å
许æ°æ®åºæå¡å¨çå¬æ¥èªä»»ä½ä¸»æºçè¿æ¥è¯·æ±ï¼
ããlisten_addresses = '*' # what IP address(es) to listen on;
ãã# comma-separated list of addresses;
ãã# defaults to 'localhost', '*' = all
ãã# (change requires restart)
ããä¿®æ¹ä¹åï¼ä¿å并éåºï¼ç¶åéèµ·æ°æ®åºï¼å°±å¯ä»¥å¨å¨è¿ç¨æºå¨ä¸è®¿é®PostgreSQLæ°æ®åºäºã
ããå¦å¤ï¼æ°æ®åºç®¡çå°è´´å£«ï¼
ããmatrixæ°æ®åºä½¿ç¨çæ¯PostgreSQLæ°æ®åºãä½ å¯ä»¥å®è£
ä¸ä¸ªç±»ä¼¼phpmyadminç管ç
温馨提示:答案为网友推荐,仅供参考