postgresqlpgbouncer

Example psql command for pgbouncer connect with SCRAM-SHA-256 and multiple DBs

What would be a valid example psql command for connecting to pgbouncer in case of valid auth_file:

"testuser" "SCRAM-SHA-256......blablaExample"

For the following conf:

auth_type=scram-sha-256
...
[databases]
targetdb = host=1.1.1.1 dbname=testdb port=5432 user=testuser password=testpw
alternativedb = host=2.2.2.2 dbname=testdb port=5432 user=testuser password=testpw
Solution 
  • psql -U testuser -d targetdb --host=pgbouncerip --port=5432
psql -U testuser -d sourcedb --host=pgbouncerip --port=5432