pg-api 0.2.0

A high-performance PostgreSQL REST API driver with rate limiting, connection pooling, and observability
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

# Production Configuration Structure

## Directory Layout

```
/etc/pg-api/                    # Main configuration directory
├── pg-api.env                  # Environment variables (secrets)
├── accounts.json               # Account configurations
└── server.json                 # Server settings

/opt/prod/pg-api/               # Application directory
├── target/release/pg-api       # Binary executable
├── logs/                       # Application logs
└── backup/                     # Backup directory

/var/lib/pg-api/                # Data directory (future use)
└── cache/                      # Cache files
```

## Security Notes

- Configuration files in `/etc/pg-api/` are owned by `root:pg-api`
- Environment file has 640 permissions (readable by root and pg-api group)
- Application runs as unprivileged user `pg-api`
- Logs are written to journal and `/opt/prod/pg-api/logs/`

## File Permissions

```bash
/etc/pg-api/pg-api.env          # 640 root:pg-api
/etc/pg-api/accounts.json       # 640 root:pg-api  
/etc/pg-api/server.json         # 644 root:root
/opt/prod/pg-api/               # 755 pg-api:pg-api
/opt/prod/pg-api/logs/          # 755 pg-api:pg-api
```