pgdog.toml

#
# minimal pgDog configuration for a single user, single
# primary database running on the same host.
#
[general]
host = "0.0.0.0"
port = 6432
shutdown_timeout = 5_000
# query_log = "queries.txt"
# broadcast_address = "224.0.0.1"
# broadcast_port = 6435
# tls_certificate = "pgdog/tests/tls/cert.pem"
# tls_private_key = "pgdog/tests/tls/key.pem"

#
# Admin database password.
#
[admin]
password = "pgdog"

#
# Simple database.
#
[[databases]]
name = "pgdog"
host = "127.0.0.1"

#
# Sharded cluster with two primaries.
#
[[databases]]
name = "pgdog_sharded"
host = "127.0.0.1"
database_name = "shard_0"
shard = 0

[[databases]]
name = "pgdog_sharded"
host = "127.0.0.1"
database_name = "shard_1"
shard = 1

#
# Read/write access to theses tables will be automatically
# sharded.
#
[[sharded_tables]]
database = "pgdog_sharded"
table = "sharded"
column = "id"
primary = true

[[sharded_tables]]
database = "pgdog_sharded"
table = "users"
column = "id"
primary = true

# [[sharded_tables]]
# database = "pgdog_sharded"
# table = "vectors"
# column = "embedding"
# primary = true
# centroids = [[
#     [1, 2, 3],
#     [100, 200, 300],
# ]]

#
# ActiveRecord sends these queries
# at startup to figure out the schema.
#
# This will route them to only one shard instead of issuing
# cross-shard queries and getting incorrect results.
#
[[manual_queries]]
fingerprint = "e78fe2c08de5f079" #[16685804461073231993]

[[manual_queries]]
fingerprint = "43258d068030bb3e" #[4838428433739463486]

[[manual_queries]]
fingerprint = "08aab2cee482a97d" #[624508100011010429]

[[manual_queries]]
fingerprint = "23cd60d5972d1712" #[2579824632033777426]

[[manual_queries]]
fingerprint = "bb38525ebeb46656" #[13490623250668217942]