search

vitabaks / postgresql_cluster

PostgreSQL High-Availability Cluster (based on "Patroni" and DCS "etcd" or "consul"). Automating with Ansible.
MIT License
1.29k stars 352 forks source link

getting "pooler error : "query_timeout_error" in pgbouncer logs #547

Closed kumarashish071092 closed 4 months ago

kumarashish071092 commented 4 months ago

if we want to check the connections getting established from connection pooling. how can we execute the "SHOW POOLS" command?

Do we have to create pgbouncer user and pgbouncer database and how it will store the active connections to debug "query_timeout_issue"?

vitabaks commented 4 months ago

if we want to check the connections getting established from connection pooling. how can we execute the "SHOW POOLS" command?

psql -h <server_ip> -p 6432 -U postgres -d pgbouncer

Do we have to create pgbouncer user and pgbouncer database and how it will store the active connections

No. You do not need to explicitly create a pgbouncer database.

"query_timeout_issue"

Please see https://github.com/vitabaks/postgresql_cluster/issues/89

kumarashish071092 commented 4 months ago

Thanks . We can close this issue now.

From: Vitaliy Kukharik @.> Sent: Monday, January 8, 2024 4:08 PM To: vitabaks/postgresql_cluster @.> Cc: Kumar Ashish @.>; Author @.> Subject: Re: [vitabaks/postgresql_cluster] getting "pooler error : "query_timeout_error" in pgbouncer logs (Issue #547)

[Email from a non-Nagarro source: please exercise caution with links and attachments]

if we want to check the connections getting established from connection pooling. how can we execute the "SHOW POOLS" command?

psql -h -p 6432 -U postgres -d pgbouncer

Do we have to create pgbouncer user and pgbouncer database and how it will store the active connections

No. You do not need to explicitly create a pgbouncer database.

— Reply to this email directly, view it on GitHubhttps://github.com/vitabaks/postgresql_cluster/issues/547#issuecomment-1880751632, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AVXUU3VER5LYHRL447NMQF3YNPEDLAVCNFSM6AAAAABBQ7ZXHKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQOBQG42TCNRTGI. You are receiving this because you authored the thread.Message ID: @.***>