LogoLogo
BlogDiscordGitHubDoltgres
  • Introduction
    • What is Doltgres?
    • Installation
    • Getting Started
  • Concepts
    • Git
      • Commits
      • Log
      • Diff
      • Branch
      • Merge
      • Conflicts
      • Remotes
      • Working Set
    • SQL
      • Databases
      • Schema
      • Tables
      • Primary Keys
      • Types
      • Indexes
      • Views
      • Constraints
      • Triggers
      • Functions
      • Procedures
      • Users/Grants
      • Transactions
      • System Variables
    • RDBMS
      • Server
      • Backups
      • Replication
  • Guides
    • Cheat Sheet
    • Replication from Postgres
  • Reference
    • Running the Server
      • Configuration
      • Access Management
      • Branch Permissions
      • Backups
      • Garbage Collection
      • Metrics
      • Replication
      • Troubleshooting
    • Version Control Features
      • Using Branches
      • Merges
      • Querying History
      • Using Remotes
      • Functions
      • System Tables
      • System Variables
    • SQL Language Support
      • Supported Functions and Operators
      • Supported Types
      • Supported SQL Commands
      • System Catalog Schema
    • Supported Clients
      • Programmatic
    • Benchmarks
      • Correctness
      • Latency
Powered by GitBook
On this page
  1. Reference
  2. Running the Server

Configuration

A Doltgres SQL server can be configured at server start time, or by setting system variables in the SQL session. The simplest way to configure server behavior is to provide a config file with the --config flag. Here's an example file:

log_level: info

behavior:
  read_only: false

listener:
  host: localhost
  port: 5432
  read_timeout_millis: 28800000
  write_timeout_millis: 28800000
  
data_dir: /var/doltgres/dbs

cfg_dir: .doltcfg

The full list of supported fields can be found by running doltgres --help.

System variables

Doltgres defines system variables that you can set in your session via the SET syntax. Many of these can be persisted, so they remain set after a server restart.

set dolt_transaction_commit 1;
PreviousRunning the ServerNextAccess Management

Last updated 3 months ago

A full list of available system variables can be found in the .

docs on system variables