Where userlist.txt contains "postgres" "some_password"
In the pgbouncer guide it says:
"Since PostgreSQL 9.0, the text files are not used anymore. Thus the auth file needs to be generated. See ./etc/mkauth.py for sample script to generate auth file from pg_shadow table. PostgreSQL MD5-hidden password format: "md5" + md5(password + username)"
Does anyone know if this is the root of the connection problem and if so how to manually generate the auth file?