pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Brainmue <brainmue@weiller.eu>
To: Francisco Olarte <folarte@peoplecall.com>
Cc: Thomas Markus <t.markus@proventis.net>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Date: Fri, 16 Jun 2023 20:18:46 +0000
Message-ID: <89c1684486557d535c3062e44073b05e@weiller.eu> (raw)
In-Reply-To: <CA+bJJbwe8fOg6-b-NvsnFdrriSu9zmRP1Twf9xTfaD0sX_ckmQ@mail.gmail.com>
References: <CA+bJJbwe8fOg6-b-NvsnFdrriSu9zmRP1Twf9xTfaD0sX_ckmQ@mail.gmail.com>
	<71943c04e05c3c13d5cd2b287909f351@weiller.eu>
	<0c2dd853-08ec-dbed-00c3-a680ae711d89@proventis.net>
	<6c3babfef3065d8e1d69b8618a1aeac3@weiller.eu>

16. Juni 2023 21:54, "Francisco Olarte" <folarte@peoplecall.com> schrieb:

> Michael:
> 
> On Fri, 16. Juni 2023 at 13:53, brainmue <brainmue@weiller.eu> wrote:
> 
>> Because with iptables or netfilter I can't forward TCP packets based on the DNS alias name. Or is
>> that possible?
> 
> The dns alias name does not reach the listening tcp socket, it is
> mapped to the target record, then finally to the A record and this is
> what is used to start the tcp connection.
> 
>> I have the same problem with nginx.
> 
> In nginx you cannot use the dns alias, but if you are using http the
> "normal" clients send it as host when they open an url. But there is
> no "host" parameter in the pg protocol. There is a dbaname, which can
> be used with the adequate software, like pgbouncer, but you said you
> do not like it.
> 
> You may try to write a small program which parses the startup message
> and redirects the connection based on the info there. I'm not sure why
> pgbouncer has not this option, but it may be because it has a lot more
> option. It does not seem to be that difficult, receive the packet,
> parse it, connect to remote, send it the packet and from there on just
> forward traffic blindly. Parsing startup seems quite simple,
> maintaining a socket pool and forwarding is simple, you could probably
> prototype that in an afternoon ( if no guru replies me "but this won't
> work because .... ).
> 
>> I just looked in the documentation again but I can't find a way to distinguish which cluster to
>> forward to based on the DNS alias.
> 
> As I asaid above, DNS alias is not avalilable to the listener. On any
> protocol. Things like http work because the clients send the dns alias
> on some place on the default usage, but you can write an http client
> which sends Host: from the uri given but connects to a different IP
> address.
> 
> Francisco Olarte.

Thank you for the detailed explanations.
I could not have explained it but it also seemed strange to me that it should go that way.
pgbouncer I will definitely look again carefully.
Maybe I already have my solution with it.

Regards
Michael





view thread (37+ messages)  latest in thread

Message-ID: <89c1684486557d535c3062e44073b05e@weiller.eu>
Permalink:  ../89c1684486557d535c3062e44073b05e@weiller.eu/
Also on:    postgresql.org/message-id/89c1684486557d535c3062e44073b05e@weiller.eu

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-general@postgresql.org
  Cc: brainmue@weiller.eu, folarte@peoplecall.com, t.markus@proventis.net
  Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.
  In-Reply-To: <89c1684486557d535c3062e44073b05e@weiller.eu>
  References: <CA+bJJbwe8fOg6-b-NvsnFdrriSu9zmRP1Twf9xTfaD0sX_ckmQ@mail.gmail.com> <71943c04e05c3c13d5cd2b287909f351@weiller.eu> <0c2dd853-08ec-dbed-00c3-a680ae711d89@proventis.net> <6c3babfef3065d8e1d69b8618a1aeac3@weiller.eu> <89c1684486557d535c3062e44073b05e@weiller.eu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox