Re: Connecting over UNIX domain sockets

On Mon, 2011-06-27 at 12:02 -0700, Phil Clay wrote:

> Apologies for resurrecting an old thread, but I'm also interested in using
> domain sockets with postgres' jdbc driver.
>
> To any potential implementors, I wanted to point out something that might be
> useful...
>
> The junixsocket project (http://code.google.com/p/junixsocket/) provides an
> implementation of java.net.Socket that uses domain sockets.  It also provides a
> mysql SocketFactory so that mysql's jdbc driver can be used with domain
> sockets.
> However, contrary to mysql's jdbc driver, postgres' jdbc driver does not appear
> to be designed in a way that a different Socket implementation could be easily
> "plugged in".

Hmm - does pg jdbc driver support IPv6 ?

If so, is it done inside java socket library ?

> If the postgres jdbc project does not want the full burden of managing the
> native code required for domain socket connectivity, perhaps one approach to
> take would be to refactor the postgres jdbc driver in such a way that a
> different mechanism for constructing sockets could be plugged in.  Then an
> implementation could be provided by junixsocket, which already has the native
> distribution mechanism.
>
> Just a thought.
>
> Phil
>

--
-------
Hannu Krosing
PostgreSQL Infinite Scalability and Performance Consultant
PG Admin Book: http://www.2ndQuadrant.com/books/