kumarashish071092

Unable to reflect postgresql parameter changes after executing playbook

13

I have added below entries in vars/main.yml file : ``` log_checkpoints = on log_connections = on log_disconnections =on log_lock_waits=0 log_temp_files=0 log_autovacuum_min_duration=0 log_error_verbosity=default log_statement=off log_min_duration_statement=10 log_line_prefix = '%t [%p]: db=%d,user=%u,app=%a,client=%h '...

Pgbouncer with LDAP

1

just a basic question. three years ago, the pgbouncer was not compatible with LDAP authentication. is there something we can do to set up connection pooling with LDAP as we...

The connection is getting timeout with errors while making conenctions with pgbouncer

1

I am getting below errors in pgbouncer.log and at the same time , connection is timed out at application level. ``` 2024-04-23 01:40:12.304 EDT [3702136] LOG S-0x56383eb72410: testclientc_supplier_connect_uat/[email protected]:35432 closing because:...

Unable to start patroni after pgbackrest restore

9

I have restored my entire cluster from a other pgbackrest host and after making the necessary changes , I was able to start the database using the below command :...

getting LOG: could not fork autovacuum worker process: Cannot allocate memory

2

I have suddenly started getting OOM errors in my Postgres cluster . I have to restart the patroni to log in to the database. If I can log in by...