Re: [gentoo-user] PosgreSQL - pg_hba.conf localhost access only

[James Cloos]

>>>>> "J" == Joseph  <syscon780@×××××.com> writes:

J> In my "pg_hba.conf" I have:

J> local	all             all             		        trust
J> host    all             all             127.0.0.1/32            trust

J> I was under impression that this is configuration is for localhost "127.0.0.1" access only.

That tells pg how to authenticate users using the unix domain socket and
users using tcp over the loopback interface.

To limit the listen_address, edit postgresql.conf in that directory.

You want to have:

  listen_addresses = 'localhost'

or:

  listen_addresses = '127.0.0.1'

to prevent any access attempts from any non-localhost ip addresses.

-JimC
-- 
James Cloos <cloos@×××××××.com>         OpenPGP: 1024D/ED7DAEA6