can't connect to pgbouncer via jdbc. unknown pkt from client: 90

[vaibhavarora]

I can connect to pgbouncer from psql and query database via that

but when connecting from the app via the JDBC, get back errors

"unknown pkt from client: 90/0x5a"

PgBouncer 1.22.1

[JelteF]

Could you share how you are connecting to PgBouncer with JDBC? And which JDBC version are you using? Also did this work before and did it break after some change, or is it the first time you are trying it?

[vaibhavarora]

@JelteF - i am connecting via jdbc:postgresql://127.0.0.1:6432/dbname

pgbouncer version - PgBouncer 1.22.1

this is the first time i am using pgbouncer. i am able to get the psql client to connect to pgbouncer. thanks for your help

[JelteF]

can you share your pgbouncer config file? And can you share logs of pgbouncer when running in very verbose mode (start it with -vvv or add verbose = 3 to the [pgbouncer] section of the config)

[JelteF]

Also double checking the dbname you use is not pgbouncer right? Because that is the admin database.

[eulerto]

What's the JDBC version? Is it a specific transaction that causes it? If so, could you share it?

[vaibhavarora]

ini file

[databases]
postgres = host=localhost port=5432 dbname=postgres

[pgbouncer]
listen_port = 6432
listen_addr = localhost
auth_type = trust
auth_file = userlist.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = xxx
ignore_startup_parameters = extra_float_digits, application_version, application_name

[vaibhavarora]

this is happening at the first connection from jdbc

[vaibhavarora]

"Also double checking the dbname you use is not pgbouncer right?"

No, it's not