General
PromptBeginner5 minmarkdown
- **Variables**: `CONTAINER_NAME`
`POSTGRES_USER`
0
Explore
Find agent skills by outcome
113,845 skills indexed with the new KISS metadata standard.
Showing 24 of 113,845Categories: Data, General, Productivity, Creative, Coding & Debugging
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
- 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
- Prepare notification hooks (e.g.
webhook
0
General
PromptBeginner5 minmarkdown
- Test restore from backup regularly
not just backup creation
0
General
PromptBeginner5 minmarkdown
- Restrict file permissions on `.env` and backup scripts (`chmod 600` for `.env`
`chmod 700` for scripts)
0
Coding & Debugging
PromptBeginner5 minmarkdown
- [ ] All credentials are sourced from environment variables
never hardcoded
0
General
PromptBeginner5 minmarkdown
After completing the backup and restore implementation
verify:
0
General
PromptBeginner5 minmarkdown
- Ensure `pg_dump`
`gzip`
0
General
PromptBeginner5 minmarkdown
- `CF_R2_ACCESS_KEY_ID`
`CF_R2_SECRET_ACCESS_KEY`
0
General
PromptBeginner5 minmarkdown
- `POSTGRES_USER`
`POSTGRES_DB`
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 necessary apt/yum packages (e.g.
aws-cli
0
General
PromptBeginner5 minmarkdown
- **Document** installation prerequisites
setup walkthrough
0
Productivity
PromptBeginner5 minmarkdown
- **Implement** automated backup scripting with `pg_dump`
`gzip` compression
0
General
PromptBeginner5 minmarkdown
- **Configure** environment variables and credentials for secure
repeatable backup and restore operations
0
Productivity
PromptBeginner5 minmarkdown
- Treat every requirement below as an explicit
trackable task.
0
Data
PromptBeginner5 minmarkdown
- **Validate** system architecture components including PostgreSQL container access
Cloudflare R2 connectivity
0
Productivity
PromptBeginner5 minmarkdown
- Assign each task a stable ID (e.g.
TASK-1.1) and use checklist items in outputs.
0
Coding & Debugging
PromptBeginner5 minmarkdown
You are a senior DevOps engineer and specialist in database reliability
automated backup/restore pipelines
0