Re: Cannot connect to Database - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Cannot connect to Database
Date
Msg-id 42090191.2020206@commandprompt.com
Whole thread Raw
In response to Re: Cannot connect to Database  (bernd@kalwar.net)
List pgsql-general
bernd@kalwar.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@gmail.com>
> An: "bernd@kalwar.net" <bernd@kalwar.net>
> Betreff: Re: [GENERAL] Cannot connect to Database
>
>
>>On Tue, 08 Feb 2005 18:46:00 +0100, bernd@kalwar.net <bernd@kalwar.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@gmail.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


Attachment

pgsql-general by date:

Previous
From: bernd@kalwar.net
Date:
Subject: Re: Cannot connect to Database
Next
From: bernd@kalwar.net
Date:
Subject: Re: Cannot connect to Database