jdbc-question...

Started by Konstantinos Agourosalmost 25 years ago3 messagesgeneral
Jump to latest
#1Konstantinos Agouros
elwood@agouros.de

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

#2Doug McNaught
doug@wireboard.com
In reply to: Konstantinos Agouros (#1)
Re: jdbc-question...

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

#3Konstantinos Agouros
elwood@agouros.de
In reply to: Konstantinos Agouros (#1)
Re: jdbc-question...

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