Euler Taveira

Results 103 comments of Euler Taveira

Postgres and pgbouncer use different API for choosing TLS protocols. Postgres uses `ssl_{min,max}_protocol_version` and pgbouncer uses `SSL_CTX_set_options`. According to the [OpenSSL documentation](https://www.openssl.org/docs/man1.1.0/man3/SSL_CTX_set_options.html), using this function to turn off protocol versions...

You didn't provide enough information. Did you check what the log says? Could you post the exact error message you got when you try to connect with a different user?...

No. See the current behavior. Option -R provides a FATAL message but the routine is not correct. Option -u provides a FATAL message but the OS user exists so the...

Are there any messages between 15:04:10 and 15:04:44? Did you check your OS log messages for IO issues? If you monitor this host, did you check OS metrics?

The command output is: ``` pgbouncer=# show state; key | value ---------+------- active | yes pause | no suspend | no (3 rows) pgbouncer=# pause; PAUSE pgbouncer=# show state; key...

I tried your setup and any user into _users_ section cannot login. Looking at the postgres logs, pgbouncer does not try to connect and execute _auth_query_ when user is from...

There is not. This message is new in 1.17 (commit ab7957160b2ec92a183f699e3112b2d0e10bfbbb). The new wording provides additional details about the failure. This error usually means that your restarted the Postgres server...

@pope1ni server version info comes from server. I bet postgres.example.com is resolving from more than one IP (with different postgres servers using them).

Execute: `sudo apt-get build-dep postgresql-10-pglogical` and try again.

@MaximBoguk Could you provide a test case? It would be useful if you provide a minimal pgbouncer.ini and the exact PHP/PDO version you are using. What `pool_mode` are you using?