Load balancer📘 Load balancerPgDog is an application layer (OSI Level 7) load balancer for PostgreSQL. ExampleThe load balancer is enabled automatically when a database has more than one host:[[ databases ]] name = " prod " host = " 10.0.0.1 " role = " primary " [[ databases ]] name = " prod " host = " 10.0.0.2 " role = " replica "Health checks📘 HealthchecksPgDog maintains a real-time list of healthy hosts. ExampleConfiguring multiple hosts for the same database with different shard numbers ( shard setting) enables sharding:[[ databases ]] name = " prod " host = " 10.0.0.1 " shard = 0 [[ databases ]] name = " prod " host = " 10.0.0.2 " shard = 1Note: read below for how to configure query routing. [[ sharded_tables ]] database = " prod " column = " user_id " # Value-specific shard mappings. ExampleConfiguring sharded schemas uses a different configuration from sharded tables:[[ sharded_schemas ]] database = " prod " name = " customer_a " shard = 0 [[ sharded_schemas ]] database = " prod " name = " customer_b " shard = 1Queries that refer tables in schema customer_a will be sent to shard 0.