Postgres Pro
Downloads
Home   >   mailing lists

Re: Question: Multiple pg clusters on one server can be reached with the standard port. - Mailing list pgsql-general

From Jeff Ross
Subject Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Date
Msg-id e34ad2b1-a41a-6000-8a24-d9813a8b4566@openvistas.net
Whole thread Raw
In response to Re: Question: Multiple pg clusters on one server can be reached with the standard port.  ("Brainmue" <brainmue@weiller.eu>)
Responses Re: Question: Multiple pg clusters on one server can be reached with the standard port.  ("Brainmue" <brainmue@weiller.eu>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: "Brainmue"
Date:
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.
Next
From: Ron
Date:
Subject: Re: Question: Multiple pg clusters on one server can be reached with the standard port.