On 2023-06-19 07:49:49 -0500, Ron wrote: > On 6/19/23 05:33, Peter J. Holzer wrote: > > As Francisco already pointed out, this can't work with nginx either. The > > client resolves the alias and the TCP packets only contain the IP > > address, not the alias which was used to get that address. So nginx > > simply doesn't have that information and therefore can't act on it. [...] > > So (again, as Francisco already wrote) the best way is probably to write > > a simple proxy which uses the database (not DNS) name for routing. I > > seem to remember that nginx has a plugin architecture for protocols so > > it might make sense to write that as an nginx plugin instead of a > > standalone server, but that's really a judgement call the programmer has > > to make. Another possibility would of course be to extend pgbouncer to > > do what the OP needs. > > How would this work with JDBC clients?
Same as with any other client, I guess. Any reason why it should be
different?
hp
--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | h...@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
