1

    nex-pi-backup-restore

    by Nex AI

    Daily backup-and-restore for a self-hosted Postgres app or Pi: a custom-format pg_dump, app-data tar, config copy, keep-window rotation, and a low-disk Telegram alert, plus a confirm-to-proceed restore, systemd timer, and idempotent install.

    Updated Jun 2026
    Security scanned
    Cursor

    $9

    · or 45 credits

    30-day refund guarantee

    Secure checkout via Stripe

    Included in download

    • Run pgvector and TimescaleDB side-by-side on a single Raspberry Pi.
    • Avoid "peer authentication failed" errors with pre-configured SCRAM auth.
    • terminal, network automation included
    • Ready for Cursor
    • Instant install

    Sample input

    Set up a new pgvector instance for my 'knowledge-base' app. I already have a native Postgres on 5432, so I need a free port and a nightly backup script.

    Sample output

    I've generated a configuration in postgres-multi/. I assigned 'knowledge-base' to port 5433 using the docker-pgvector template.

    • Port 5433 added to PORT-REGISTRY.md
    • Generated docker-compose.yml with 127.0.0.1:5433 binding
    • Added nightly backup entry to backup-all.sh (14-day retention)

    About This Skill

    The daily backup-and-restore system Nex AI runs in production. backup.sh dumps a Postgres database in custom format, tars the served app data, copies non-secret config, rotates old backups to a keep-window, and checks disk usage with a Telegram alert past a threshold. restore.sh is the deliberate, confirm-to-proceed companion that brings a backup back with a clean pg_restore. A systemd service and timer run it daily, and an idempotent install script wires it all up. Secrets are never backed up, and a commented off-box copy hook makes the backup durable. Field-verified, parameterised, restore added.

    Use Cases

    • Run pgvector and TimescaleDB side-by-side on a single Raspberry Pi.
    • Avoid "peer authentication failed" errors with pre-configured SCRAM auth.
    • Maintain a central registry to prevent database port collisions.
    • Automate nightly gzipped backups for every Postgres instance on the host.
    • Migrate from expensive managed Postgres to self-hosted multi-instance setups.

    Reviews

    No reviews yet - be the first to share your experience.

    Only users who have downloaded or purchased this skill can leave a review.

    Security Scanned

    Passed automated security review

    Permissions

    Terminal / Shell
    Network Access

    Allowed Hosts

    nex-ai.be
    api.telegram.org

    File Scopes

    nex-pi-backup-restore/**

    Tags

    postgres
    docker
    database-administration
    devops
    linux
    backup

    Compatible with SKILL.md-compatible agents including Claude Code, Cursor, and Cline.

    Creator

    Nex AI

    Founder of Nex AI. I build production-grade Claude Skills from systems that actually run: multi-tenant SaaS, Telegram agents, Raspberry Pi infrastructure, 3D multiplayer rooms. Every skill ships battle-tested patterns, not theory. 33+ open source skills published, commercial catalog growing.

    Frequently Asked Questions

    Learn More About AI Agent Skills

    More Premium Skills

    Multi-Agent Orchestration Master Library

    Transform Claude Code into a coordinated multi-agent system. Battle-tested tmux orchestration patterns, YAML task queues, event-driven communication, and parallel worker management for 8+ agents.

    $157 installs

    designing-hybrid-context-layers

    Architects the right retrieval strategy for every query — teaching your agent when to use RAG, a knowledge graph, or a temporal index instead of defaulting to vector search for everything.

    $1015 installs

    consumer-motivation-analyzer

    Go beyond surface-level feedback to uncover the psychological drivers and hidden motivations behind buyer behavior.

    $199 installs

    ai-automation-qa-pack

    Professional QA & UAT documentation generator for AI automation agencies and complex agent deployments.

    $58 installs

    $9