pg-api 0.2.0

A high-performance PostgreSQL REST API driver with rate limiting, connection pooling, and observability
[Unit]
Description=PostgreSQL API Service
After=network.target postgresql.service
Wants=postgresql.service

[Service]
Type=simple
User=pg-api
Group=pg-api
WorkingDirectory=/opt/prod/pg-api

# Configuration file in /etc for security
EnvironmentFile=/etc/pg-api/pg-api.env

ExecStart=/opt/prod/pg-api/target/release/pg-api
Restart=always
RestartSec=10

# Security
NoNewPrivileges=true
PrivateTmp=true
ProtectSystem=strict
ProtectHome=true

# Allow writing to logs directory only
ReadWritePaths=/opt/prod/pg-api/logs

# Resource Limits
LimitNOFILE=65536
MemoryMax=2G
CPUQuota=400%

# Logging
StandardOutput=journal
StandardError=journal
SyslogIdentifier=pg-api

[Install]
WantedBy=multi-user.target