pgSentinel/env.template at main · pgElephant/pgSentinel · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
# pgSentinel Environment Configuration Template
# =============================================
# Copy this file to .env and configure for your environment

#==============================================================================
# Backend Configuration
#==============================================================================

# Database for storing pgSentinel metadata
DATABASE_URL=postgresql://postgres:password@localhost:5432/pgsentinel

# PostgreSQL cluster for insights (primary database)
INSIGHTS_DATABASE_URL=postgresql://postgres:password@localhost:5432/postgres

# Redis for caching and session management
REDIS_URL=redis://localhost:6379/0

# pgbalancer configuration file path
PGBALANCER_CONFIG=/path/to/pgbalancer.conf

# Logging level (DEBUG, INFO, WARNING, ERROR, CRITICAL)
LOG_LEVEL=INFO

# Security
SECRET_KEY=change-this-to-a-random-secret-key
ALLOWED_HOSTS=*

# API Server
API_HOST=0.0.0.0
API_PORT=8000
API_WORKERS=4

#==============================================================================
# Frontend Configuration
#==============================================================================

# Backend API URL
NEXT_PUBLIC_API_URL=http://localhost:8000

# WebSocket URL
NEXT_PUBLIC_WS_URL=ws://localhost:8000/ws/live

# Disable Next.js telemetry
NEXT_TELEMETRY_DISABLED=1

#==============================================================================
# PostgreSQL Connection Settings
#==============================================================================

# Primary node
POSTGRES_PRIMARY_HOST=localhost
POSTGRES_PRIMARY_PORT=5432
POSTGRES_PRIMARY_USER=postgres
POSTGRES_PRIMARY_PASSWORD=password
POSTGRES_PRIMARY_DB=postgres

# Replica nodes (comma-separated)
POSTGRES_REPLICA_HOSTS=localhost:5433,localhost:5434

#==============================================================================
# Monitoring Configuration
#==============================================================================

# Enable pg_stat_insights
ENABLE_PG_STAT_INSIGHTS=true

# Metrics collection interval (seconds)
METRICS_COLLECTION_INTERVAL=5

# Prometheus retention
PROMETHEUS_RETENTION_TIME=30d