Running PostgreSQL in LAN
Published: Thursday, 16 November 2017 15:38
Written by dedet
These are the files you should modify to make your PostgreSQL accepting connection from LAN
- Edit file /etc/postgresql/[version number]/main/postgresql.conf
- file line listen_addresses, commented it and add your server ip address, examplelisten_addresses = '10.0.0.1,localhost'
- Edit file /etc/postgresql/[version number]/main/pg_hba.conf
- add this linehost all all 10.0.0.0 255.255.255.0 md5