39 lines
1.1 KiB
Markdown
39 lines
1.1 KiB
Markdown
# Prefect Worker - PostgreSQL Backup
|
|
|
|
Image Docker pour un worker Prefect dédié aux sauvegardes de bases de données PostgreSQL vers un stockage S3-compatible (Garage).
|
|
|
|
## Contenu
|
|
|
|
- **Base** : `prefecthq/prefect:3-python3.12`
|
|
- **Outils PostgreSQL** : `pg_dump`, `pg_restore`, `psql`
|
|
- **Python** : `boto3`, `psycopg2-binary`
|
|
|
|
## Utilisation
|
|
|
|
### Dans docker-compose
|
|
|
|
```yaml
|
|
prefect-worker:
|
|
image: gitea.arnodo.fr/damien/prefect-worker-pg-backup:latest
|
|
environment:
|
|
- PREFECT_API_URL=http://prefect-server:4200/api
|
|
command: prefect worker start --pool pg-backup-pool --type process
|
|
depends_on:
|
|
- prefect-server
|
|
```
|
|
|
|
### Variables d'environnement requises pour les flows
|
|
|
|
| Variable | Description |
|
|
|----------|-------------|
|
|
| `PREFECT_API_URL` | URL de l'API Prefect |
|
|
| `AWS_ACCESS_KEY_ID` | Clé d'accès S3 (Garage) |
|
|
| `AWS_SECRET_ACCESS_KEY` | Secret S3 (Garage) |
|
|
| `AWS_ENDPOINT_URL` | Endpoint S3 (ex: `https://s3.garage.example.com`) |
|
|
|
|
## Build local
|
|
|
|
```bash
|
|
docker build -t prefect-worker-pg-backup:latest images/prefect-worker-pg-backup/
|
|
```
|