Title
#users-public
q

Quant Genie

10/29/2022, 1:56 PM
Hi, I am trying to configure pgbouncer between Java client & Questdb I cloudn't establish connection..can someone help or point me to any tutorial? My pgbouncer.ini
[databases]
admin = host=127.0.0.1 dbname=qdb port=9000

[pgbouncer]
listen_addr = 127.0.0.1
listen_port = 6432
auth_type = trust
auth_file = /etc/pgbouncer/users.txt
logfile = /etc/pgbouncer/pgbouncer.log
pidfile = /etc/pgbouncer/pgbouncer.pid
My JDBC client:
properties.setProperty("user", "admin");
properties.setProperty("password", "quest");
connection = DriverManager.getConnection("jdbc:<postgresql://127.0.0.1:6432/qdb>",properties);

Exception: 
Exception in thread "main" java.lang.RuntimeException: org.postgresql.util.PSQLException: The connection attempt failed.
Caused by: org.postgresql.util.PSQLException: The connection attempt failed.
	at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:331)
Alex Pelagenko

Alex Pelagenko

10/31/2022, 10:25 AM
Hi, QuestDB pg wire port is
8812