pg_dump version mismatch PostgreSQL Origin: Data OSI layer 7 · Application Last updated 14 Oct 2026

pg_dump: error: aborting because of server version mismatch

Your pg_dump client is older than the server you’re dumping.

Exact message you may see aborting because of server version mismatchserver version: 16
Seen on: PostgreSQL

Meaning

pg_dump must be the same major version or newer than the server. Ubuntu’s default client lags behind managed servers (RDS, Supabase).

Common causes

  • Old postgresql-client package
  • Multiple versions installed, older one first on PATH

⚡ Quick fix

  1. Install the matching client (apt install postgresql-client-16 from the PGDG repo)
  2. Call the versioned binary directly
  3. Run pg_dump inside a postgres:16 container

Detailed fix by platform

Docker

  1. docker run --rm postgres:16 pg_dump "$DATABASE_URL" > dump.sql

How to diagnose

  1. Versions — pg_dump --version vs SELECT version()
  2. Recent change — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

08P01 — ERROR: bind message supplies 2 parameters, but prepared statement requires 1 (PostgreSQL)08P012BP01 — ERROR: cannot drop table x because other objects depend on it (PostgreSQL)2BP0157014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014nodemon crashed — [nodemon] app crashed - waiting for file changes before starting... (Node.js)nodemon crashednpx executable — npm ERR! could not determine executable to run (npm)npx executablepg_restore text dump — pg_restore: error: input file appears to be a text format dump. Please use psql. (PostgreSQL)pg_restore text dumpreact-scripts not found — 'react-scripts' is not recognized as an internal or external command / react-scripts: command not found (React)react-scripts not fou…pg_dump v…

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.