Missing or erroneus pg_hba.conf file

[Jim Seymour]

Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
connection from my PC to the server, using pgAdminIII, I get the message
local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 172.17.0.0 255.255.0.0 trust

[snip]

There is an issue, as yet not understood (last I knew), with some
versions of (?) Solaris and IP-address-with-netmask configuration
entries in pg_hba.conf. Try changing your two "host" lines to:

# IPv4-style local connections:
host all all 127.0.0.1/32 trust
host all all 172.17.0.0/16 trust

and see if that doesn't resolve your problem.

Jim

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Tom Lane]

My server is working with pgsql 7.4.2 and Unix Solaris 8.
[ this pg_hba.conf line doesn't work: ]
host all all 127.0.0.1 255.255.255.255 trust

We've seen some reports suggesting that Solaris has a problem with the
all-ones netmask. You could probably get it to work either by
loosening the netmask a little:

host all all 127.0.0.1 255.255.255.0 trust

or by using CIDR style:

host all all 127.0.0.1/32 trust

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match