Configure ParticleDB
Check the installed options
Section titled “Check the installed options”particledb start --helpFlags vary between distributions. The installed help is the reference for accepted names and values. Avoid copying options from a different release.
Configuration sources
Section titled “Configuration sources”The server uses built-in defaults, an optional TOML configuration file, and command-line overrides. Command-line settings override the corresponding file settings.
particledb start --config ./config.toml --data-dir ./pdb-dataAn explicitly named configuration file must exist. Keep credentials out of files committed to source control.
Common settings
Section titled “Common settings”| Purpose | Setting |
|---|---|
| Persistent records | --data-dir |
| HTTP SQL and health address | --http-addr |
| SQL client address | --pg-addr |
| Redis client address | --redis-addr |
| Initial account | --pg-username |
| Password file | --pg-password-file |
| Authentication | --auth-method |
| TLS | --tls-cert, --tls-key |
| Durability | --durability |
| KV durability (Redis-compatible endpoint) | --kv-durability |
| Concurrency control | --concurrency-control |
| Default session isolation | --default-isolation |
| Server memory | --max-server-memory |
| Query memory | --max-statement-memory |
| Monitoring endpoint | --metrics-addr |
Transactions and persistence
Section titled “Transactions and persistence”--concurrency-control (default optimistic), --durability (default groupsync) and --kv-durability (default async) are separate settings; changing one does not change the others.
An explicit transaction defaults to READ COMMITTED unless the session or server default changes. Choosing strict-optimistic does not change that default. Read concurrency, isolation and durability before selecting a mode.
Before changing a setting
Section titled “Before changing a setting”Review the relevant connection, authentication, durability or memory guide. Restart a development instance and verify the result before applying it to production.
Related
Section titled “Related”This site uses Google Analytics cookies to count visits. Privacy · License