POSTGRES RESTORE TEST PROCEDURE v1

STATUS: DRAFT
OWNER: single-owner system
DEFAULT RULE: never restore over production without explicit confirmation

PURPOSE

This document defines a safe restore-test procedure for Jarvis PostgreSQL backups.

BACKUP SOURCE

Private backup directory:
- /volume1/docker/jarvis/db/backups

Backup format:
- jarvis_postgres_YYYYMMDD_HHMMSS.sql.gz

SAFETY RULES

Never restore directly into production jarvis-db unless explicitly approved.
Never place database dumps in public/.
Never paste backup contents into chat.
Never expose database credentials.
Always test restore into a separate temporary database or temporary container first.

RESTORE TEST GOAL

Confirm that a selected backup file can be:
1. found
2. decompressed
3. restored into a temporary PostgreSQL instance
4. queried successfully
5. deleted safely after the test

RECOMMENDED TEST METHOD

Use a temporary PostgreSQL container with a temporary volume.
Do not overwrite jarvis-db.
Do not reuse production database storage.

HIGH-LEVEL STEPS

1. Select latest backup from private backup directory.
2. Start temporary PostgreSQL restore-test container.
3. Restore backup into temporary database.
4. Run a simple query to confirm restore success.
5. Stop and remove temporary restore-test container.
6. Remove temporary restore-test volume.
7. Record test result in JARVIS_CORE_STATUS_v0.1.txt.

RESTORE TEST STATUS

Not executed yet.

NEXT ACTION

Create and run a temporary restore-test command set.

END