Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    PostgreSQL 14 EOL Upgrade: Move 14, 15 or 16 to PostgreSQL 18 or 19

    1

    Plan and run a safe PostgreSQL major upgrade before 14 reaches end of life on 12 November 2026: target choice, tested pre-flight scan, runbook, rollback and verification.

    $3

    Secure checkout via Stripe

    Money-back guarantee

    Converts to your local currency at checkout

    Security scanned
    PostgreSQL 14 EOL Upgrade: Move 14, 15 or 16 to PostgreSQL 18 or 19

    PostgreSQL 14 EOL Upgrade: Move 14, 15 or 16 to PostgreSQL 18 or 19

    Example session with this skill installed

    Our production Postgres 14.22 (Ubuntu, 600 GB, PostGIS and pgvector, one streaming standby) must be upgraded before EOL with under 15 minutes of downtime. Plan it.

    • Read your context and instructions
    • Compiled the postgresql 14 eol

    A Markdown plan: summary (14 to 18 via pg_upgrade --link, ~10 min downtime, go once PostGIS/pgvector 18 packages are confirmed), inventory table, 20-row pre-flight table with results and fixes (e.g. initdb --no-data-checksums, drop adminpack, set search_path on two index functions), timed runbook, standby rebuild steps, rollback plan, verification checklist and official sources.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    PostgreSQL 14 receives its final release on 12 November 2026. After that date it gets no security or bug fixes. This skill helps your agent plan the upgrade with evidence and without guesswork.

    What it does

    • Chooses the target version (17, 18 or 19) and the upgrade method (pg_upgrade --link/--clone/--swap/--copy, dump/restore, logical replication or a managed-service upgrade) using clear decision tables.
    • Runs a read-only pre-flight SQL scan across every database. It covers 20 checks for every version you cross (15, 16, 17, 18 and 19). Examples: reg* columns that block pg_upgrade, settings that were removed, adminpack, PL/Python 2, unlogged partitioned tables, btree_gist inet/cidr indexes, MD5 passwords and functions used by indexes that have no fixed search_path.
    • Catches the data checksum mismatch that makes pg_upgrade to 18 or later fail on older clusters.
    • Writes a timed runbook with exact commands, a rollback plan for each method, and a verification checklist that includes the new statistics step.
    • Gives the official postgresql.org source for every rule.

    Included files

    • SKILL.md: procedure, decision tables, runbook, output format and pitfalls
    • reference/preflight-queries.sql: the tested, read-only scan
    • reference/incompatibilities.md: each change from 15 to 19, with its impact and fix
    • reference/methods.md: runbooks for logical replication, dump/restore and managed services

    Does not perform the upgrade unattended; you run the commands. Provider-specific managed-service consoles are covered as a checklist only. PostgreSQL 19 items come from the RC release notes and should be checked against the final GA notes.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    No reviews yet

    Be one of the first to try it. Every listed skill goes through the trust checks below.

    Security scanned

    Checked by our 8-point scan before listing

    Fresh listing

    Recently published to Agensi

    Money-back guarantee

    Doesn't do what its page promises? You get your money back.

    Trust & safety

    Security scan

    Security scan passed 13 days ago

    Requires

    PostgreSQL superuser or admin access
    psql

    Permissions

    Pre-flight queries are read-only. Upgrade commands are shown for the user to run; nothing is executed without the user.

    Listed13 days ago

    What's inside

    Frequently Asked Questions

    Plan and run a safe PostgreSQL major upgrade before 14 reaches end of life on 12 November 2026: target choice, tested pre-flight scan, runbook, rollback and verification.

    This skill uses the open SKILL.md standard. Use it through an MCP-compatible agent connected to Agensi, and check the compatibility information on this page for confirmed agents and required capabilities.

    Connect your AI agent to Agensi through MCP, then ask it to use PostgreSQL 14 EOL Upgrade: Move 14, 15 or 16 to PostgreSQL 18 or 19 on your task. Your agent loads the latest approved version each time. Paid skills require a purchase or active subscription. Skill files are not available for download; your licence does not allow you to save, copy or export any part of a skill.

    New in Security