Tuesday, July 7, 2015

Running PostgreSQL in LAN

These are the files you should modify to make your PostgreSQL accepting connection from LAN
  1. postgresql.conf
    1. Edit file /etc/postgresql/[version number]/main/postgresql.conf
    2. file line listen_addresses, commented it and add your server ip address, examplelisten_addresses = '10.0.0.1,localhost'
  2. pg_hba.conf
    1. Edit file /etc/postgresql/[version number]/main/pg_hba.conf
    2. add this linehost    all         all         10.0.0.0       255.255.255.0    md5

No comments:

Post a Comment