pg_restore text dump PostgreSQL Origin: Data OSI layer 7 · Application Last updated 13 Oct 2026

pg_restore: error: input file appears to be a text format dump. Please use psql.

A plain .sql dump was given to pg_restore, which only reads custom/directory/tar formats.

Exact message you may see input file appears to be a text format dump
Seen on: PostgreSQL

Meaning

pg_dump default output is plain SQL — restore it with psql. Use pg_dump -Fc to create archives for pg_restore.

Common causes

  • Plain SQL dump passed to pg_restore
  • Backup tool/hosting panel exported plain SQL while the restore script expects -Fc archives

⚡ Quick fix

  1. psql -d dbname -f dump.sql
  2. Create archives with pg_dump -Fc next time

Detailed fix by platform

PostgreSQL

  1. psql "$DATABASE_URL" -f dump.sql

How to diagnose

  1. Format — Plain text or custom archive?
  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_dump version mismatch — pg_dump: error: aborting because of server version mismatch (PostgreSQL)pg_dump version misma…react-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_restor…

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.