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

From: Jeff Ross <jross(at)openvistas(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-16 16:16:54
Message-ID: e34ad2b1-a41a-6000-8a24-d9813a8b4566@openvistas.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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 can set up pgbouncer to authenticate in postgres:

https://www.2ndquadrant.com/en/blog/understanding-user-management-in-pgbouncer/
See the "auth_query, auth_user" section.

https://www.2ndquadrant.com/en/blog/pg-phriday-securing-pgbouncer/

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2023-06-16 16:56:00 Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Previous Message Brainmue 2023-06-16 16:05:51 Re: Question: Multiple pg clusters on one server can be reached with the standard port.