Thread: jdbc-question...

jdbc-question...

From
elwood@agouros.de (Konstantinos Agouros)
Date:
Hi,

can the driver connect to the database only via tcp/ip? Or can I use it one
the same machine to connect directly?

Konstantin
--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

Re: jdbc-question...

From
Doug McNaught
Date:
elwood@agouros.de (Konstantinos Agouros) writes:

> can the driver connect to the database only via tcp/ip? Or can I use it one
> the same machine to connect directly?

The JDBC driver can only use TCP/IP (since Java doesn't support Unix
sockets) but you can certainly se it on the same machine.  You just
need to start the postmaster with '-i' to allow TCP connections.  The
default pg_hba.conf only allows connections on the local interface
(127.0.0.1) so it's reasonably secure.

-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time...          --Dylan

Re: jdbc-question...

From
elwood@agouros.de (Konstantinos Agouros)
Date:
In <m3elshg39k.fsf@belphigor.mcnaught.org> doug@wireboard.com (Doug McNaught) writes:

>elwood@agouros.de (Konstantinos Agouros) writes:

>> can the driver connect to the database only via tcp/ip? Or can I use it one
>> the same machine to connect directly?

>The JDBC driver can only use TCP/IP (since Java doesn't support Unix
>sockets) but you can certainly se it on the same machine.  You just
>need to start the postmaster with '-i' to allow TCP connections.  The
>default pg_hba.conf only allows connections on the local interface
>(127.0.0.1) so it's reasonably secure.
Which wouldn't help me much if it is an applet.... \:)

Konstantin

>-Doug
>--
>The rain man gave me two cures; he said jump right in,
>The first was Texas medicine--the second was just railroad gin,
>And like a fool I mixed them, and it strangled up my mind,
>Now people just get uglier, and I got no sense of time...          --Dylan

>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood@agouros.de
Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
----------------------------------------------------------------------------
"Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres