Skip site navigation (1) Skip section navigation (2)

Problem connecting to postgres

From: "Graham Bartlett" <gbartlett(at)gamet(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Problem connecting to postgres
Date: 2002-12-11 19:37:55
Message-ID: 000301c2a14c$cd83ab60$4f01010a@gbartletpc (view raw or flat)
Thread:
Lists: pgsql-novice
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!





In response to

Responses

pgsql-novice by date

Next:From: Devinder K RajputDate: 2002-12-11 19:55:45
Subject: Re: Problem connecting to postgres
Previous:From: Pam WamplerDate: 2002-12-11 19:19:30
Subject: problem trying to install pgaccess

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group