From: | Thomas Markus <t(dot)markus(at)proventis(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Question: Multiple pg clusters on one server can be reached with the standard port. |
Date: | 2023-06-19 04:06:33 |
Message-ID: | c5f9c9b4-7a1f-8a35-406c-d7cc34285bcd@proventis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Am 16.06.23 um 13:53 schrieb Brainmue:
>
>> possible solutions:
>> * set up a firewall rule to forward connection
>> * use a tcp proxy (nginx can do that)
>> * check pg_bouncer
>>
>> best regards
>> Thomas
> Hello Thomas,
>
> Thank you for your quick reply.
>
> With firewall you mean an additional software, right?
> Because with iptables or netfilter I can't forward TCP packets based on the DNS alias name. Or is
> that possible?
>
> I have the same problem with nginx. 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.
> Do you have an example for me?
>
> We have already looked at pgbouncer and it works with that but unfortunately you have to do the
> authentication in pgbouncer. Which we don't like so much.
>
> Regards,
> Michael
You cant setup firewall rules basedon dns names. firewall rules are
based on ip adresses and dns resolution happens on rule creation.
I dont have an example for nginx. As I remember nginx resolves dns names
only for variables. So setup a variable with your hostname and use this
variable in your server definition.
best regards
Thomas
Attachment | Content-Type | Size |
---|---|---|
OpenPGP_0x9794716335E9B5AF.asc | application/pgp-keys | 3.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Junwang Zhao | 2023-06-19 05:20:22 | Re: timetz need more bytes than timestamptz |
Previous Message | jian he | 2023-06-19 03:52:52 | timetz need more bytes than timestamptz |