123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151 |
- [general]
- host = "0.0.0.0"
- port = 6432
- enable_prometheus_exporter = true
- prometheus_exporter_port = 9930
- connect_timeout = 1000
- healthcheck_timeout = 1000
- healthcheck_delay = 30000
- shutdown_timeout = 5000
- ban_time = 60
- log_client_connections = false
- log_client_disconnections = false
- autoreload = 15000
- tls_certificate = ".circleci/server.cert"
- tls_private_key = ".circleci/server.key"
- admin_username = "admin_user"
- admin_password = "admin_pass"
- [pools.sharded_db]
- pool_mode = "transaction"
- default_role = "any"
- query_parser_enabled = true
- primary_reads_enabled = true
- sharding_function = "pg_bigint_hash"
- [pools.sharded_db.users.0]
- username = "sharding_user"
- password = "sharding_user"
- pool_size = 9
- statement_timeout = 0
- [pools.sharded_db.users.1]
- username = "other_user"
- password = "other_user"
- pool_size = 21
- statement_timeout = 30000
- [pools.sharded_db.shards.0]
- servers = [
- [ "127.0.0.1", 5432, "primary" ],
- [ "localhost", 5432, "replica" ]
- ]
- database = "shard0"
- [pools.sharded_db.shards.1]
- servers = [
- [ "127.0.0.1", 5432, "primary" ],
- [ "localhost", 5432, "replica" ],
- ]
- database = "shard1"
- [pools.sharded_db.shards.2]
- servers = [
- [ "127.0.0.1", 5432, "primary" ],
- [ "localhost", 5432, "replica" ],
- ]
- database = "shard2"
- [pools.simple_db]
- pool_mode = "session"
- default_role = "primary"
- query_parser_enabled = true
- primary_reads_enabled = true
- sharding_function = "pg_bigint_hash"
- [pools.simple_db.users.0]
- username = "simple_user"
- password = "simple_user"
- pool_size = 5
- statement_timeout = 30000
- [pools.simple_db.shards.0]
- servers = [
- [ "127.0.0.1", 5432, "primary" ],
- [ "localhost", 5432, "replica" ]
- ]
- database = "some_db"
|