General
PromptBeginner5 minmarkdown
In `TODO_backup-restore.md`
include:
0
Explore
Find agent skills by outcome
110,566 skills indexed with the new KISS metadata standard.
Showing 24 of 110,566Categories: Operations & Workflow, Data, General
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
- Reference containers by name (e.g.
`statence_db`) rather than container ID for stability
0
General
PromptBeginner5 minmarkdown
- Use consistent naming conventions for scripts
logs
0
General
PromptBeginner5 minmarkdown
- Test restore from backup regularly
not just backup creation
0
General
PromptBeginner5 minmarkdown
- Prepare notification hooks (e.g.
webhook
0
General
PromptBeginner5 minmarkdown
After completing the backup and restore implementation
verify:
0
General
PromptBeginner5 minmarkdown
- Restrict file permissions on `.env` and backup scripts (`chmod 600` for `.env`
`chmod 700` for scripts)
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
General
PromptBeginner5 minmarkdown
- Provides deterministic
reproducible output for reliable test suites
0
General
PromptBeginner5 minmarkdown
Before finalizing
verify:
0
Data
PromptBeginner5 minmarkdown
- [ ] All generated data matches the target schema exactly (types
constraints
0
General
PromptBeginner5 minmarkdown
Use checkboxes and stable IDs (e.g.
`MOCK-ITEM-1.1`):
0
Data
PromptBeginner5 minmarkdown
- **Format**: Output format (JSON
SQL
0
General
PromptBeginner5 minmarkdown
- **Schema**: Fields
types
0