Postgres: missing or erroneous pg_hba.conf file

Question

I have 2 machines sitting on my desk and connected to the same IP network. I'm trying to connect an application from one machine to the postgres database on the other. At first the host with the application on it was giving me the PSQLException:

FATAL: no pg_hba.conf entry for host "192.168.1.18", user "user1", database "test", SSL off

So I edited my pg_hba.conf file to accept the IP address: 192.168.1.18, by adding the line below at the end of the file:

host    pnp         all         192.168.1.18      trust

Then I got another type of error message:

FATAL: missing or erroneous pg_hba.conf file

Is there anything I'm missing here?

Thanks, Lancelot

David Schmitt · Accepted Answer · 2009-04-13 19:15:37Z

13

You have to specify the netmask of the host too. So either "192.168.1.18/32" or "192.168.1.18 255.255.255.255" instead of the bare IP address.

See the pg_hba.conf file chapter in the online manual for details.

answered Apr 13, 2009 at 19:15

David Schmitt

59.5k27 gold badges124 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres: missing or erroneous pg_hba.conf file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related