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

[Jeff Ross <jross@xxxxxxxxxxxxxx>]

> 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