Works with the AI Agents you already use
PostgreSQL 14 EOL Upgrade: Move 14, 15 or 16 to PostgreSQL 18 or 19
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
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_gistinet/cidr indexes, MD5 passwords and functions used by indexes that have no fixedsearch_path. - Catches the data checksum mismatch that makes
pg_upgradeto 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 pitfallsreference/preflight-queries.sql: the tested, read-only scanreference/incompatibilities.md: each change from 15 to 19, with its impact and fixreference/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
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
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 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
Permissions
Pre-flight queries are read-only. Upgrade commands are shown for the user to run; nothing is executed without the user.