Works with the AI tools you already use

    CClaude CodeCCursorCCodex CLIGGitHub CopilotGGemini CLIVVS CodeWWindsurf+15 more

    Nex Postgres Multi Instance

    by Nex AI

    1

    Manage multiple Postgres versions and extensions on one Linux box with a port registry and unified backups.

    Secure checkout via Stripe

    0 installsSecurity scanned

    See it in action

    You say

    I need to add a pgvector instance for a new project called 'brain-search' on my Ubuntu box. Port 5432 is already taken by my main app.

    Your agent does

    I've generated the postgres-multi/ package. I've assigned 'brain-search' to port 5433 (the next free port in your registry) using the docker-pgvector template.

    Registry Entry added: 5433 | brain-search-db | brain-search | pgvector pg16 | docker | 2024-05-20

    Run this to start: docker compose -f postgres-multi/docker-instances/docker-compose-brain-search.yml up -d

    What you get

    Run pgvector and TimescaleDB side-by-side on a single Raspberry Pi or VPS.Fix 'Peer authentication failed' errors by generating correct pg_hba configs.Avoid port collisions with a managed registry for all local database instances.Automate nightly gzipped backups for every Postgres instance on the host.Isolate app data using named Docker volumes and local-only network bindings.

    About this skill

    Run Multiple Postgres Instances Peacefully

    Running multiple databases on a single Linux machine often leads to port collisions, authentication headaches ("Peer authentication failed"), and backup gaps. This skill implements a battle-tested operational pattern for developers who need to host multiple isolated Postgres environments—such as pgvector, TimescaleDB, and vanilla Postgres—side-by-side without version conflicts or high managed-database bills.

    What it does

    The skill generates a hard-coded infrastructure folder (postgres-multi/) containing everything needed to manage your database fleet:

    • Port Registry: A canonical mapping to prevent port collisions between services.
    • Multi-Instance Configs: Templates for both Debian-managed clusters and Docker containers (pgvector, TimescaleDB, vanilla).
    • Hardened Security: Automatic 127.0.0.1 binding and SCRAM-SHA-256 authentication setup to prevent credential-spraying.
    • Unified Backups: A central shell script that iterates through your registry to perform gzipped nightly dumps with auto-pruning.
    • Fix Scripts: One-shot utilities to resolve common "peer authentication" issues and check port availability.

    Why use this skill?

    Unlike a generic AI prompt, this skill enforces strict operational standards: it ensures every volume is app-prefixed to prevent accidental data deletion, insists on non-root app roles, and provides a documented upgrade path for when the next Postgres major version ships. It transforms a messy "db-on-a-box" setup into a professional, registry-backed database platform.

    Built by Nex AI. More skills and info at nex-ai.be and slopsome.com.

    How to install

    Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill passes our trust checks below.

    Security scanned

    Passed our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    30-day refund

    Not a fit? Get your money back

    Trust & safety

    Security scanned

    Verified clean 11 days ago

    Listed1 month ago
    Updated11 days ago

    Creator

    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

    Popular in Data Engineering