Re: Question: Multiple pg clusters on one server can be reached with the standard port.

From: "Brainmue" <brainmue(at)weiller(dot)eu>
To: "Dominique Devienne" <ddevienne(at)gmail(dot)com>, "Thomas Markus" <t(dot)markus(at)proventis(dot)net>
Cc: 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 11:30:54
Message-ID: d4f1602054e047f54cb93b0ec74c61e1@weiller.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

19. Juni 2023 13:17, "Dominique Devienne" <ddevienne(at)gmail(dot)com> schrieb:

> On Mon, Jun 19, 2023 at 1:01 PM Thomas Markus <t(dot)markus(at)proventis(dot)net> wrote:
>
>> Am 19.06.23 um 12:33 schrieb Peter J. Holzer:
>>> As Francisco already pointed out, this can't work with nginx either.
>> anyway, fw or nginx cant look into tcp streams
> Traefik can proxy PostgreSQL, I've read, so maybe that's something you could try.

Thanks for the tip.
As I understand Traefik but he can also only the same as HAProxy.
So he does not read the protocol itself and can not make the distribution.
PGBouncer can actually do it and it also forwards to different backends.
But we are not finished with the tests yet.
But it looks already good.

Regards
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-06-19 12:49:49 Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Previous Message Dominique Devienne 2023-06-19 11:17:47 Re: Question: Multiple pg clusters on one server can be reached with the standard port.