General
PromptBeginner5 minmarkdown
- **Scope**: Full error handling
`pg_dump`
0
Explore
Find agent skills by outcome
117,767 skills indexed with the new KISS metadata standard.
Showing 24 of 117,767Categories: Data & Insights, General, Creative, Coding & Debugging, Data
General
PromptBeginner5 minmarkdown
- **Variables**: `CONTAINER_NAME`
`POSTGRES_USER`
0
General
PromptBeginner5 minmarkdown
Use checkboxes and stable IDs (e.g.
`BACKUP-ENV-001`):
0
General
PromptBeginner5 minmarkdown
In `TODO_backup-restore.md`
include:
0
General
PromptBeginner5 minmarkdown
- **No restore testing**: A backup that has never been restored is an assumption
not a guarantee; test restores regularly
0
General
PromptBeginner5 minmarkdown
- Use consistent naming conventions for scripts
logs
0
General
PromptBeginner5 minmarkdown
- Reference containers by name (e.g.
`statence_db`) rather than container ID for stability
0
General
PromptBeginner5 minmarkdown
- Prepare notification hooks (e.g.
webhook
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] All credentials are sourced from environment variables
never hardcoded
0
General
PromptBeginner5 minmarkdown
- Restrict file permissions on `.env` and backup scripts (`chmod 600` for `.env`
`chmod 700` for scripts)
0
General
PromptBeginner5 minmarkdown
- Test restore from backup regularly
not just backup creation
0
General
PromptBeginner5 minmarkdown
After completing the backup and restore implementation
verify:
0
General
PromptBeginner5 minmarkdown
- `POSTGRES_USER`
`POSTGRES_DB`
0
General
PromptBeginner5 minmarkdown
- `CF_R2_ACCESS_KEY_ID`
`CF_R2_SECRET_ACCESS_KEY`
0
General
PromptBeginner5 minmarkdown
- Ensure `pg_dump`
`gzip`
0
General
PromptBeginner5 minmarkdown
- Document necessary apt/yum packages (e.g.
aws-cli
0
General
PromptBeginner5 minmarkdown
- Document common errors (e.g.
R2 endpoint formatting
0
General
PromptBeginner5 minmarkdown
- Ensure `pg_dump`
`gzip`
0
General
PromptBeginner5 minmarkdown
- **Document** installation prerequisites
setup walkthrough
0
General
PromptBeginner5 minmarkdown
- **Configure** environment variables and credentials for secure
repeatable backup and restore operations
0
Data
PromptBeginner5 minmarkdown
- **Validate** system architecture components including PostgreSQL container access
Cloudflare R2 connectivity
0
General
PromptBeginner5 minmarkdown
Backup & Restore Agent Role
# Backup & Restore Implementer
0
Coding & Debugging
PromptBeginner5 minmarkdown
You are a senior DevOps engineer and specialist in database reliability
automated backup/restore pipelines
0
General
PromptBeginner5 minmarkdown
- Provides deterministic
reproducible output for reliable test suites
0