Euler Taveira

Results 167 comments of Euler Taveira

If we want to expand SHOW command to support options, my suggestion is something like `SHOW POOLS [ ( option1 [value1], option2 [value2], ... ) ]` It is easier to...

@adnanhamdussalam check your HA Proxy logs. Maybe the .33 is not healthy. I mean it didn't pass the check. I also think you can use [option pgsql-check](https://www.haproxy.com/documentation/haproxy-configuration-tutorials/service-reliability/health-checks/#postgresql-health-checks) instead of `option...

Silence here. Closing.

Add it to [ignore_startup_parameters](https://www.pgbouncer.org/config.html#ignore_startup_parameters) in your `pgbouncer.ini`.

pgbench fails if it cannot open all required connections. See https://github.com/postgres/postgres/blob/master/src/bin/pgbench/pgbench.c#L7442-L7451 I expect that PgBouncer opens connections up to the `max_client_conn` limit (like in this example that I have `max_client_conn...

I didn't try that specify version (`3.2.1-dev`) but I tried the released version (`3.2.1`). It works for me. ``` $ lsb_release -a No LSB modules are available. Distributor ID: Debian...

I think you misunderstood the `pg_md5` usage. If you run: ``` $ ./pg_md5 secret 5ebe2294ecd0e0f08eab7690d2a6ee69 ``` you get a hash that not what Postgres or PgBouncer expects. If you want...

Using the same example: ``` postgres=# select usename, passwd, 'md5' || md5('secret' || usename) from pg_shadow where usename = 'test'; usename | passwd | ?column? ---------+-------------------------------------+------------------------------------- test | md5cb08e6781ef34c8ecb06e1be269a6bdc |...

It seems a network issue or HAProxy issue. Check your logs. According to the PgBouncer log that you shared, there is no issues (NOISE is not an error message.)

> [WARNING] (9) : Server Standby/timescale3 is DOWN, reason: Layer7 wrong status, code: 503, info: "Service Unavailable", check duration: 1ms. 2 active and 0 backup servers left. 0 sessions active,...