Open
Description
Name and Version
bitnami/pgbouncer:latest
What steps will reproduce the bug?
Hello,
I test pgbouncer on aws ec2 with local Docker and I want to use a custom file to start. After reading documentation, it seemed easy:
docker run --name pgbouncer \
-v /path/to/pgbouncer-persistence/conf/:/bitnami/pgbouncer/conf/ \
bitnami/pgbouncer:latest
but in reality, they askfor environment variables:
docker run --name pgbouncer \
> -v /local/pgb_conf/:/bitnami/pgbouncer/conf/ \
> bitnami/pgbouncer:latest
pgbouncer 16:32:30.85 INFO ==>
pgbouncer 16:32:30.86 INFO ==> Welcome to the Bitnami pgbouncer container
pgbouncer 16:32:30.86 INFO ==> Subscribe to project updates by watching https://github.com/bitnami/containers
pgbouncer 16:32:30.86 INFO ==> Did you know there are enterprise versions of the Bitnami catalog? For enhanced secure software supply chain features, unlimited pulls from Docker, LTS support, or application customization, see Bitnami Premium or Tanzu Application Catalog. See https://www.arrow.com/globalecs/na/vendors/bitnami/ for more information.
pgbouncer 16:32:30.86 INFO ==>
pgbouncer 16:32:30.87 INFO ==> ** Starting PgBouncer setup **
pgbouncer 16:32:30.89 INFO ==> Validating settings in PGBOUNCER_* env vars...
pgbouncer 16:32:30.89 ERROR ==> POSTGRESQL_PASSWORD must be set
This is because the custom file is not seen?
My files are generated inthe same folder:
admin@XXX:/local/pgb_conf$ ll
total 20
-rw------- 1 1001 1001 1237 Jun 3 17:45 ca.crt
-rw-r--r-- 1 1001 1001 1237 Jun 3 17:45 pgbouncer.crt
-rw-r--r-- 1 1001 1001 971 Jun 3 17:45 pgbouncer.ini
-rw-r--r-- 1 1001 1001 1704 Jun 3 17:45 pgbouncer.key
-rw-r----- 1 1001 1001 249 Jun 3 17:45 userlist.txt
Pgbouncer.ini:
[databases]
test= dbname=test port=5432 host=xxx.rds.amazonaws.com
[pgbouncer]
listen_addr = *
listen_port = 6432
auth_type = md5
pool_mode = session
server_reset_query = DISCARD ALL
ignore_startup_parameters = extra_float_digits
max_client_conn = 5000
default_pool_size = 50
min_pool_size = 10
reserve_pool_size = 0
reserve_pool_timeout = 0
listen_backlog = 2000
server_lifetime = 600
server_idle_timeout = 600
server_round_robin = 1
log_connections = 0
log_disconnections = 0
log_pooler_errors = 1
stats_period = 1
admin_users = admin
stats_users = stats,zabbix_aws
dns_max_ttl = 1
tcp_keepalive = 1
tcp_keepidle = 300
server_tls_sslmode = require
auth_file = /bitnami/pgbouncer/conf/userlist.txt
client_tls_sslmode = require
client_tls_key_file = /bitnami/pgbouncer/conf/pgbouncer.key
client_tls_cert_file = /bitnami/pgbouncer/conf/pgbouncer.crt
client_tls_ca_file = /bitnami/pgbouncer/conf/ca.crt
[users]
Can you help me understand what I miss?
Regards