Postgres Pro
Downloads
Home   >   mailing lists

Problem connecting to postgres - Mailing list pgsql-novice

From Graham Bartlett
Subject Problem connecting to postgres
Date
Msg-id 000301c2a14c$cd83ab60$4f01010a@gbartletpc
Whole thread Raw
In response to problem trying to install pgaccess  (Pam Wampler <Pam_Wampler@taylorwhite.com>)
List pgsql-novice
Tree view 
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!

pgsql-novice by date:

Previous
From: Pam Wampler
Date:
Subject: problem trying to install pgaccess
Next
From: Wim
Date:
Subject: Re: Problem connecting to postgres