bernd@xxxxxxxxxx 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@xxxxxxxxx>
An: "bernd@xxxxxxxxxx" <bernd@xxxxxxxxxx>
Betreff: Re: Cannot connect to Database
On Tue, 08 Feb 2005 18:46:00 +0100, bernd@xxxxxxxxxx <bernd@xxxxxxxxxx>
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@xxxxxxxxx
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
begin:vcard
fn:Joshua D. Drake
n:Drake;Joshua D.
org:Command Prompt, Inc.
adr:;;PO Box 215;Cascade Locks;Oregon;97014;USA
email;internet:jd@xxxxxxxxxxxxxxxxx
title:Consultant
tel;work:503-667-4564
tel;fax:503-210-0334
note:Command Prompt, Inc. is the largest and oldest US based commercial PostgreSQL support provider. We provide the only commercially viable integrated PostgreSQL replication solution, but also custom programming, and support. We authored the book Practical PostgreSQL, the procedural language plPHP, and adding trigger capability to plPerl.
x-mozilla-html:FALSE
url:http://www.commandprompt.com/
version:2.1
end:vcard
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
