Alec Rooney comments

Results 12 comments of


                                            Alec Rooney

PGBouncer config

Hi @rgherta I believe you can customize pgbouncer by editing the postgrescluster definition and adding something like the following: ``` spec: proxy: pgBouncer: config: global: pool_mode: transaction max_client_connection: 200 ```

pgbouncer - adding user does not work

I tried that and that does not work. A user is created and the secret for that user suggests that it can connect to pgbouncer. But the pgbouncer secret with...

pgbouncer - adding user does not work

This was adding a user after the cluster was created. But was worried that might be an issue so I deleted the pgbouncer proxy in the postgrescluster definition which deleted...

pgbouncer - adding user does not work

@digitalcraig I figured out my issue and maybe have a clue as to why it worked for you sometimes but not other times. It does not work if the user...

[ECS] [request] User Defined Networks

👍 need this for elasticsearch nodes

Any advice about running pgo in a service mesh like istio?

@gowrisankar22 we paused our istio rollout but planning to look at using pg as an external service because of issues with pgo and istio.

Is there a way to send the logs from the database container in this directory: /pgdata/<db_name>/pg_log to k8s

- Our retention policy is 7 days typically - We typically just discard old logs - We send the logs to an elk stack and use kibana for the visualizations/searching

use Integer instead of Fixnum to remove deprecation warning

👍

pgo 4.5.0 scheduled backup failing with [UnknownError] remote-0 process on '10.244.140.50' terminated unexpectedly [255]: kex_exchange_identification: Connection closed by remote host\nERROR: [056]: unable to find primary cluster - cannot proceed\n]

Seems not intermittent. All scheduled backups are failing. Manual backups work fine for this cluster. On another cluster on same version of pgo and database the scheduled backups work fine.

Disabling/Hiding some teams endpoints.

Also interested in this. As someone who isn't super familiar with grape, it would be great to have a recommendation/documentation for best way to approach this i.e. option 0. Also,...