public inbox for [email protected]
help / color / mirror / Atom feedFrom: Craig Ringer <[email protected]>
To: Stephen Frost <[email protected]>
Cc: James Cassell <[email protected]>
Cc: PostgreSQL Yum Package List <[email protected]>
Subject: Re: Can we stop defaulting to 'ident'?
Date: Fri, 20 Dec 2019 11:06:26 +0800
Message-ID: <CAMsr+YHAipW2tH-334ZLcROqx4Q55mB7JZY8CyV0AZMi_yfB2g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAMsr+YFCuBGWh4=aM-K2LCsBEwcrqm=pphKKHEH09vHwXcspow@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
On Fri, 20 Dec 2019 at 01:32, Stephen Frost <[email protected]> wrote:
> Greetings,
>
> * James Cassell ([email protected]) wrote:
> > Peer does not work with TCP connections, and I haven't figured how to
> get,e.g., third-party Java applications working without TCP.
>
> The entire point of peer was to segregate the very insecure 'ident' from
> the actually quite secure 'peer' auth, so, no, it's not going to work
> over TCP connections- that's more-or-less the point.
>
> Regarding a JDBC connection, you can pass in a "socketFactory", as I
> understand it (though I'm no JDBC expert, I'd suggest you address issues
> you have with that to the JDBC list):
>
> https://jdbc.postgresql.org/documentation/head/connect.html
>
Right. PgJDBC doesn't actually have to support it directly, since you can
pass your own socketFactory, such as one provided by
https://github.com/kohlschutter/junixsocket or
https://github.com/jnr/jnr-unixsocket .
As the Java Language specification does not provide for UNIX socket support
and no widely used JVM bundles AF_UNIX socket support there's no way for
PgJDBC to directly support unix sockets. We could add support for it in
jdbc:postgresql:// URLs, but we'd have to do a runtime search of the
classpath to find a suitable SocketFactory using a list of known unix
socket library implementations ... so why bother? If the user has to
install a 3rd party library to do it anyway, they can specify a JDBC URL
argument too.
So PgJDBC already has everything it needs there IMO, except perhaps a hint
in the documentation. Patches welcome :)
--
Craig Ringer http://www.2ndQuadrant.com/
2ndQuadrant - PostgreSQL Solutions for the Enterprise
view thread (54+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: Can we stop defaulting to 'ident'?
In-Reply-To: <CAMsr+YHAipW2tH-334ZLcROqx4Q55mB7JZY8CyV0AZMi_yfB2g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox