I have an environment where users connect to pgpool, and pgpool connects to redshift. With JDBC and psql, it works really well because there is an option in the Postgres JDBC driver called "preferQueryMode" which allows me to change the query mode to "simple" - GitHub - pgjdbc/pgjdbc: Postgresql JDBC Driver
When I try to use tableau to connect to pgpool, it doesn't work because apparently tableau driver uses the extended query protocol. I would like to know how can I switch from extended query to simple query protocol, like the example above about JDBC Postgres driver?
Hi Felipe Garcia,
Before we investigate further, could you please tell me what error is popping at the screen when "it doesn't work"?
Is it a communication error? If so, have you tried opening the pgsql.port: 8060?