Re: postgresql SSL off

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/