Open oxymor0n opened 4 years ago
@oxymor0n that could be the case. I don't have a ton of experience using pgpool. If you manage to diagnose the issue a PR is welcome
See https://github.com/metabase/metabase/issues/6295#issuecomment-771929300 -- this is an issue with PgPool returning a different key than normal PostgreSQL does
based on https://github.com/metabase/metabase/issues/6295 and my own experience trying to get Metabase to connect to a pgpool-managed Postgresql cluster, it seems like there is a problem with how Toucan builds SQL queries, which leads to the above error when such queries are executed against pgpool.
Maybe Toucan is trying to leverage a feature of Postgres that pgpool doesn't support?
Or perhaps Toucan is working correctly but Metabase is not implementing it right?