pgBouncer configuration is repeting parameters in the pgbouncer.ini file
Summary
pgbouncer configuration is repeting parameters in the pgbouncer.ini
file
Current Behaviour
Create a pooling configuration with some parameters:
apiVersion: stackgres.io/v1beta1
kind: SGPoolingConfig
metadata:
namespace: test-db
name: poolconfig
spec:
pgBouncer:
pgbouncer.ini:
pool_mode: transaction
max_client_conn: '2000'
default_pool_size: '50'
log_connections: '1'
log_disconnections: '1'
log_stats: '1'
Then the configuration on the pgbouncer sidecar is created as is shown below:
bash-4.4$ cat /etc/pgbouncer/pgbouncer.ini
[databases]
* = port = 5432
[pgbouncer]
listen_port = 6432
listen_addr = 127.0.0.1
unix_socket_dir = /var/run/postgresql
auth_type = md5
auth_user = authenticator
auth_query = SELECT usename, passwd FROM pg_shadow WHERE usename=$1
admin_users = postgres
stats_users = postgres
application_name_add_host = 1
ignore_startup_parameters = extra_float_digits
max_db_connections = 100
max_user_connections = 100
default_pool_size = 100
log_connections = 1
default_pool_size = 50
pool_mode = transaction
max_db_connections = 90
log_disconnections = 1
max_client_conn = 2000
log_stats = 1
having:
max_db_connections = 100
max_db_connections = 90
and
default_pool_size = 50
default_pool_size = 100
Expected Behaviour
Having a configuration with no parameters repeated.
Environment
- StackGres version:
0.9.1
- Kubernetes version:
1.17.0
- Cloud provider or hardware configuration:
minikube