PgBouncer Authentication
What Is pgbouncer ? pgbouncer is a lightweight PostgreSQL connection pooler. Any target application can be connected to pgbouncer as if it were a PostgreSQL server, and pgbouncer will create a connection to the actual server, or it will reuse one of its existing connections. The aim of pgbouncer is to lower the performance impact of opening new connections to PostgreSQL. To know more about pgbouncer visit https://pgbouncer.github.io/usage.html How pgbouncer work? As shown in below diagram , this is default authentication method most of us are using.When user try to connect database with specified user & password , PgBouncer will perform a lookup of the provided username/password against userlist.txt to verify that the credentials are correct, and then the username/password are sent to Postgres for an actual database login. What's wrong with using userlist.txt ? A general process is You create user/role in database. Get md5 password from p...