Re: Cannot connect to Database

bernd(at)kalwar(dot)net wrote:
>>Do you have TCP/IP activated in postgresql.conf ? Are you trying to
>>connect via localhost (127.0.0.1) or some other route?
>
>
> I start the Server with the -i option, so TCP/IP is activated, isn't it?
> I want to connect by localhost to my database.

From the localhost can you:

psql -h 127.0.0.1 -U postgres template1

?

Sincerely,

Joshua D. Drake

>
> thx,
>
> Bernd
>
> --- Ursprüngliche Nachricht ---
> Datum: 08.02.2005 18:52
> Von: Lonni J Friedman <netllama(at)gmail(dot)com>
> An: "bernd(at)kalwar(dot)net" <bernd(at)kalwar(dot)net>
> Betreff: Re: [GENERAL] Cannot connect to Database
>
>
>>On Tue, 08 Feb 2005 18:46:00 +0100, bernd(at)kalwar(dot)net <bernd(at)kalwar(dot)net>
>
> wrote:
>
>>>Hi,
>>>
>>>everytime I try to connect to my Database with a Java-Applikation, I
>>>recieve only the following Exception:
>>>
>>>org.postgresql.util.PSQLException: A connection error has occurred:
>>>org.postgresql.util.PSQLException: FATAL: kein pg_hba.conf-Eintrag
>
> für
>
>>>Host »127.0.0.1«, Benutzer »postgres«, Datenbank »test«, SSL aus
>>>
>>>I get the same error-message with other applications, e.g. pgaccess,
>
> too.
>
>>>My pg_hba.conf looks like:
>>>
>>># TYPE DATABASE USER IP-ADDRESS IP-MASK
>>>METHOD
>>>
>>>host all all 127.0.0.1 255.255.255.255
>
> trust
>
>>>The database and the applications are on the same host.
>>>
>>>What could be the problem.
>>
>>Do you have TCP/IP activated in postgresql.conf ? Are you trying to
>>connect via localhost (127.0.0.1) or some other route?
>>
>>--
>>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>L. Friedman netllama(at)gmail(dot)com
>>LlamaLand http://netllama.linux-sxs.org
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage, and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com