pgbouncer_userlist_generator I don't have psycopg2 installed everywhere, so mkauth.py doesn't work for me. I use this simple shell script instead. The only caveat is it either requires using the postgres user.