Configure PgBouncer to authenticate against PostgreSQL and rely less on userlist.txt

Posted on by

PgBouncer is a lightweight connection pooler. When a user connects to PgBouncer, the user’s username and password is checked against userlist.txt file. If you haven’t installed PostgreSQL, see Install PostgreSQL 9.6 on Ubuntu 16.04 and reset postgres password Disadvantage of userlist.txt The disadvantage is whenever new user is added to PostgreSQL, the user’s username and password […]

Install PostgreSQL 9.6 on Ubuntu 16.04 and reset postgres password

Posted on by

PostgreSQL is really easy to install on Ubuntu 16.04 LTS. This example uses command line to install PostgreSQL and vim to edit files. These settings are for non-production use. Set source to get PostgreSQL Set up the right source so that we can install PostgreSQL with apt-get. Enter sudo vim /etc/apt/sources.list.d/pgdg.list Type i to go to INSERT […]