Re: postgresql SSL off

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tony Smith <quickcur(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgresql SSL off
Date: 2005-07-12 22:52:21
Message-ID: 42D449A5.6030200@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tony Smith wrote:
> When I was trying to connect my databse with jdbc, I
> got the following error message:
>
> org.postgresql.util.PSQLException: Connection
> rejected: FATAL: no pg_hba.conf entry for host
> "mydomain", user "xxxx", database "myDB", SSL off.
>

You need to setup your pg_hba.conf to allow remote connections to
the database for the user.

http://www.postgresql.org/docs/7.4/static/client-authentication.html

Sincerely,

Joshua D. Drake

> When I run in dos console "psql myDB..." it works
> fine.
>
> My jdbc code is at a different at different domain
> from the database machine.
>
> Thanks,
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Find what you need with new enhanced search.
> http://info.mail.yahoo.com/mail_250
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-07-12 22:52:58 Re: user privilege to create c function
Previous Message TJ O'Donnell 2005-07-12 22:43:43 user privilege to create c function