devhero · August 1, 2015 10:23
diff --git a/pg_listen_tcpip b/pg_listen_tcpip
 # ubuntu
 /etc/postgresql/9.1/main
 # centos
 /var/lib/pgsql/9.x/data

 postgresql.conf
 listen_addresses = '*'

 pg_hba.conf
 host all all 0.0.0.0/0 md5 

 # tips
 host all all 192.168.0.0/24 md5 
 This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24. 
 You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process.
	# ubuntu
	/etc/postgresql/9.1/main
	# centos
	/var/lib/pgsql/9.x/data

	postgresql.conf
	listen_addresses = '*'

	pg_hba.conf
	host all all 0.0.0.0/0 md5

	# tips
	host all all 192.168.0.0/24 md5
	This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24.
	You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process.