If you are on 7.3x, this should work:
host all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 10.1.1.0 255.255.255.0 trust
on earlier versions:
host all trust
host all 127.0.0.1 255.255.255.255 trust
host all 10.1.1.0 255.255.255.0 trust
hth,
Devinder
"Graham Bartlett"
<gbartlett@gamet.com> To: pgsql-novice@postgresql.org
Sent by: cc:
pgsql-novice-owner@pos Subject: [NOVICE] Problem connecting to postgres
tgresql.org
12/11/2002 01:37 PM
After installing Postgres I tried to make a connection to the DB. I made
sure to use the '-i' to enable JDBC connection. I'm receiving the
following error:
"No pg_hba.conf entry for host 10.1.1.79, user gpms, database gpms"
I have created the gpms user and gpms database. I can connect to the
database only when I add:
host all 10.1.1.79 255.255.255.255 trust
to the pg_hba.conf file.
I never had to do this before. I simply want to enable all IPs to
connect to the database without specifying every one of those IPs in the
pg_hba.conf file. How do I do this?
Thanks!
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly