How to enable debug mode in postgres about postgres-operator HOT 4 CLOSED

Hi @Alansyf Sorry you are having issues. A helpful doc to reference is located here this will enable you to change/tweak postgres settings. Another good reference is this blog which will give you an example to change logging if you wish to do so. I also found this doc to be helpful with routing information for pgbouncer. Please feel free to reach out on our Discord server if you need other assistance as well.

from postgres-operator.

Hi @ValClarkson , Thanks for your useful docs.
I read and find the solution turn on debug and find the configuration finally.

So in pgbouncer.ini, there is

[databases]
* = host=mlflow-pg-ha-primary port=5432

so everything are going to the primary.

Does it mean, pgbouncer actually is not the one can help split write and read traffic. (Write to master and read to slvve)

from postgres-operator.

Hi @Alansyf, I'm glad the doc's helped you turn on debugging! Did you happen to look at this doc? It talks about how to load balance via an external tool with pgbouncer.

from postgres-operator.

Thanks, i understand now, need another tool to support LB.

from postgres-operator.