postgresql.confā¢1.71 kB
# PostgreSQL configuration for Tiger MCP production
# Connections and authentication
listen_addresses = '*'
port = 5432
max_connections = 100
superuser_reserved_connections = 3
# Memory settings (adjust based on available RAM)
shared_buffers = 256MB
effective_cache_size = 1GB
maintenance_work_mem = 64MB
work_mem = 4MB
# Write-ahead logging
wal_level = replica
wal_buffers = 16MB
min_wal_size = 1GB
max_wal_size = 4GB
checkpoint_completion_target = 0.7
checkpoint_timeout = 5min
checkpoint_warning = 30s
# Query tuning
random_page_cost = 1.1
effective_io_concurrency = 200
# Logging
log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_truncate_on_rotation = on
log_rotation_age = 1d
log_rotation_size = 10MB
log_min_messages = info
log_error_verbosity = default
log_line_prefix = '%m [%p] %q%u@%d '
log_timezone = 'UTC'
# Lock management
deadlock_timeout = 1s
# Statement timeout
statement_timeout = 30s
idle_in_transaction_session_timeout = 60s
# Autovacuum
autovacuum = on
autovacuum_max_workers = 3
autovacuum_naptime = 1min
autovacuum_vacuum_threshold = 50
autovacuum_analyze_threshold = 50
# Statistics
track_counts = on
track_functions = all
track_activity_query_size = 1024
# Locale settings
datestyle = 'iso, mdy'
timezone = 'UTC'
lc_messages = 'en_US.utf8'
lc_monetary = 'en_US.utf8'
lc_numeric = 'en_US.utf8'
lc_time = 'en_US.utf8'
default_text_search_config = 'pg_catalog.english'
# SSL (if certificates are available)
# ssl = on
# ssl_cert_file = 'server.crt'
# ssl_key_file = 'server.key'
# Shared preload libraries
# shared_preload_libraries = ''
# Connection security
password_encryption = scram-sha-256