Newer
■
■
■
■
■
■
■
■
■
■
Older
30 lines
|
0.802kb
| 1 |
# autoSMART Database Configuration |
|
| 2 |
# PostgreSQL connection settings |
|
| 3 | ||
| 4 |
[database] |
|
| 5 |
host = localhost |
|
| 6 |
port = 5432 |
|
| 7 |
database = autosmart |
|
| 8 |
username = autosmart_user |
|
| 9 |
password = secure_password_here |
|
| 10 |
schema = smart_monitoring |
|
| 11 | ||
| 12 |
# Connection pool settings |
|
| 13 |
max_connections = 20 |
|
| 14 |
connection_timeout = 30 |
|
| 15 |
query_timeout = 60 |
|
| 16 | ||
| 17 |
# Data retention policies |
|
| 18 |
retention_raw_data = 365 # days to keep raw SMART readings |
|
| 19 |
retention_predictions = 180 # days to keep AI predictions |
|
| 20 |
retention_alerts = 90 # days to keep alert history |
|
| 21 | ||
| 22 |
# Backup settings |
|
| 23 |
backup_enabled = true |
|
| 24 |
backup_schedule = "0 2 * * *" # Daily at 2 AM |
|
| 25 |
backup_retention = 30 # days to keep backups |
|
| 26 | ||
| 27 |
[performance] |
|
| 28 |
batch_insert_size = 1000 |
|
| 29 |
vacuum_schedule = "0 3 * * 0" # Weekly vacuum |
|
| 30 |
analyze_schedule = "0 4 * * *" # Daily analyze |