Changeset View
Changeset View
Standalone View
Standalone View
data/defaults.yaml
Show First 20 Lines • Show All 1,388 Lines • ▼ Show 20 Lines | pgbouncer::config_params: | ||||
client_tls_sslmode: allow | client_tls_sslmode: allow | ||||
client_tls_ca_file: /etc/ssl/certs/ssl-cert-snakeoil.pem | client_tls_ca_file: /etc/ssl/certs/ssl-cert-snakeoil.pem | ||||
client_tls_key_file: /etc/ssl/private/ssl-cert-snakeoil.key | client_tls_key_file: /etc/ssl/private/ssl-cert-snakeoil.key | ||||
client_tls_cert_file: /etc/ssl/certs/ssl-cert-snakeoil.pem | client_tls_cert_file: /etc/ssl/certs/ssl-cert-snakeoil.pem | ||||
server_tls_sslmode: allow | server_tls_sslmode: allow | ||||
listen_port: "%{hiera('swh::deploy::db::pgbouncer::port')}" | listen_port: "%{hiera('swh::deploy::db::pgbouncer::port')}" | ||||
listen_addr: | listen_addr: | ||||
- 127.0.0.1 | - 127.0.0.1 | ||||
- 192.168.100.210 | - "%{hiera('pgbouncer::listen_addr')}" | ||||
auth_type: "hba" | auth_type: "hba" | ||||
auth_file: /etc/pgbouncer/userlist.txt | auth_file: /etc/pgbouncer/userlist.txt | ||||
auth_hba_file: /etc/postgresql/11/secondary/pg_hba.conf | auth_hba_file: "%{hiera('pgbouncer::auth_hba_file')}" | ||||
admin_users: | admin_users: | ||||
- "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | - "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | ||||
- olasd | - olasd | ||||
pool_mode: session | pool_mode: session | ||||
server_reset_query: DISCARD ALL | server_reset_query: DISCARD ALL | ||||
max_client_conn: 2000 | max_client_conn: 2000 | ||||
default_pool_size: 2000 | default_pool_size: 2000 | ||||
max_db_connections: 2000 | max_db_connections: 2000 | ||||
max_user_connections: 2000 | max_user_connections: 2000 | ||||
log_connections: 0 | log_connections: 0 | ||||
log_disconnections: 0 | log_disconnections: 0 | ||||
pgbouncer::user: postgres | pgbouncer::user: postgres | ||||
pgbouncer::group: postgres | pgbouncer::group: postgres | ||||
# swh::deploy::db::pgbouncer::user::password in private data | # swh::deploy::db::pgbouncer::user::password in private data | ||||
pgbouncer::userlist: | pgbouncer::userlist: | ||||
- user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | - user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | ||||
password: "%{hiera('swh::deploy::db::pgbouncer::user::password')}" | password: "%{hiera('swh::deploy::db::pgbouncer::user::password')}" | ||||
pgbouncer::databases: | pgbouncer::databases: [] | ||||
# swh | |||||
- source_db: "%{hiera('swh::deploy::storage::db::dbname')}" | |||||
host: prado.internal.softwareheritage.org | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::db::main::port')}" | |||||
# swh-deposit | |||||
- source_db: "%{hiera('swh::deploy::deposit::db::dbname')}" | |||||
host: "%{hiera('swh::deploy::deposit::db::host')}" | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::deposit::db::port')}" | |||||
# swh-scheduler | |||||
- source_db: "%{hiera('swh::deploy::scheduler::db::dbname')}" | |||||
host: "%{hiera('swh::deploy::scheduler::db::host')}" | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::scheduler::db::port')}" | |||||
# swh-scheduler-updater | |||||
- source_db: "%{hiera('swh::deploy::scheduler::updater::backend::db::dbname')}" | |||||
host: "%{hiera('swh::deploy::scheduler::updater::backend::db::host')}" | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::scheduler::updater::backend::db::port')}" | |||||
# swh-vault | |||||
- source_db: "%{hiera('swh::deploy::vault::db::dbname')}" | |||||
host: "%{hiera('swh::deploy::vault::db::host')}" | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::vault::db::port')}" | |||||
# swh-lister | |||||
- source_db: "%{hiera('swh::deploy::worker::lister::db::name')}" | |||||
host: "%{hiera('swh::deploy::worker::lister::db::host')}" | |||||
auth_user: "%{hiera('swh::deploy::db::pgbouncer::user::login')}" | |||||
port: "%{hiera('swh::deploy::worker::lister::db::port')}" | |||||
swh::deploy::directory: "%{hiera('swh::conf_directory')}/deploy" | swh::deploy::directory: "%{hiera('swh::conf_directory')}/deploy" | ||||
swh::deploy::group: swhdeploy | swh::deploy::group: swhdeploy | ||||
swh::deploy::public_key: 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDWrJX/uUss/EYZaTp2EIsZgg3ZSH8JcNZV5gBdNZ7EHcQcqxYUCqmwv9Ss3xT8n9kIrH6iz/vquqf84XR+keoZK3bsp50tMOY8LJWpcl/JK2XD6ovoJrHPu+iAroLkE59RdTa1Vz+jF67Q2UuG9f0nKwL4rnkeWTyuK/zAbyHyYKFQntkkwMr5/YTU8sjl/4aNF/2Ww8hitdi2GORlCjav2bB0wyPBA2e8sMt8Hp9O4TIWg/RD6vPX+ZvuFaB/Lw/Hv21622QGTHoZiO92/8/W9/t24il6SU4z96ZGfXqdUZkpPYKBGwyIkZkS4dN6jb4CcRlyXTObphyu3dAlABRt swhworker@worker01' | swh::deploy::public_key: 'ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQDWrJX/uUss/EYZaTp2EIsZgg3ZSH8JcNZV5gBdNZ7EHcQcqxYUCqmwv9Ss3xT8n9kIrH6iz/vquqf84XR+keoZK3bsp50tMOY8LJWpcl/JK2XD6ovoJrHPu+iAroLkE59RdTa1Vz+jF67Q2UuG9f0nKwL4rnkeWTyuK/zAbyHyYKFQntkkwMr5/YTU8sjl/4aNF/2Ww8hitdi2GORlCjav2bB0wyPBA2e8sMt8Hp9O4TIWg/RD6vPX+ZvuFaB/Lw/Hv21622QGTHoZiO92/8/W9/t24il6SU4z96ZGfXqdUZkpPYKBGwyIkZkS4dN6jb4CcRlyXTObphyu3dAlABRt swhworker@worker01' | ||||
swh::deploy::storage::conf_directory: "%{hiera('swh::conf_directory')}/storage" | swh::deploy::storage::conf_directory: "%{hiera('swh::conf_directory')}/storage" | ||||
swh::deploy::storage::conf_file: "%{hiera('swh::deploy::storage::conf_directory')}/storage.yml" | swh::deploy::storage::conf_file: "%{hiera('swh::deploy::storage::conf_directory')}/storage.yml" | ||||
swh::deploy::storage::user: swhstorage | swh::deploy::storage::user: swhstorage | ||||
▲ Show 20 Lines • Show All 2,005 Lines • Show Last 20 Lines |