OTF Postgres
activeWorkspace
[OTF] Optimified
Created
Tue Mar 24
Updated
Tue Mar 24
Content
## Overview
Shared Postgres instance for Optimified's Railway services. Used by n8n, Mattermost, and Umami.
## Infrastructure
- **Platform:** Railway
- **Railway Project:** otf-n8n-mattermost-umami
- **Consumers:** n8n (primary + worker), Mattermost, Umami
## Environment Variables
| Variable | Purpose |
|----------|---------|
| `DATABASE_PUBLIC_URL` | Public connection URL |
| `DATABASE_URL` | Internal connection URL |
| `PGDATA` | Data directory path |
| `PGDATABASE` | Default database name |
| `PGHOST` | Internal hostname |
| `PGPASSWORD` | Auth password |
| `PGPORT` | Port |
| `PGUSER` | Auth user |
| `POSTGRES_DB` | Database name (init) |
| `POSTGRES_PASSWORD` | Password (init) |
| `POSTGRES_USER` | User (init) |
| `RAILWAY_DEPLOYMENT_DRAINING_SECONDS` | Graceful shutdown timeout |
| `SSL_CERT_DAYS` | SSL certificate validity period |