PostgreSQL pg_hba.conf

Pg_hba.conf is a client authentication configuration file

METHOD specifies how the client's authentication is handled. Commonly used are ident,md5,password,trust,reject.

PostgreSQL only listens to local ports by default, and Netstat-tuln only sees "TCP 127.0.0.1:5432 LISTEN".

Modify the listen_address=* in the postgresql.conf to listen on all ports so that the remote can log on to the database via TCP/IP, NETSTAT-TULN will see "TCP 0.0.0.0:5432 LISTEN ”。

1, allow local use PGAdmin3 login database, database address localhost, user user1, database user1db:

host    user1db    user1    127.0.0.1/32    md5

2, allow 10.1.1.0~10.1.1.255 network segment login database:

host    all    all    10.1.1.0/24    md5

3. Trust 192.168.1.10 Login Database:

host    all    all    192.168.1.10/32    trust

PostgreSQL pg_hba.conf