* postgresql remote connect / postgresql 원격 연결 허용

큰세상2000 2022. 1. 29. 18:31

참조사이트

How to Allow Remote Access to PostgreSQL database

I have PostgreSQL 9.2 Installed in Windows 7 and I have windows XP installed in Virtual Machine, how do I connect these two databases and allow remote access to add/edit the database from both Syst...

stackoverflow.com

postgreSQL Data 디렉토리의 pg_hba.conf 파일의 "# IPv4 local connections" 내용을수정한다

ex) d:\PostgreSQL\14\data\pg_hba.conf

# IPv4 local connections
# IP 대역 허용 ( 192.168.219.x)
host    all             all             192.168.219.0/24            scram-sha-256


# 특정 IP 허용 
host    all             all             123.124.125.126/32       scram-sha-256