Cant Taking Backup:

pg_dump: [archiver (db)] query failed: ERROR: could not read block 56 in file "base/16393/11908": Invalid argument

pg_dump: [archiver (db)] query was: SELECT t.tableoid, t.oid, t.relname AS indexname, pg_catalog.pg_get_indexdef(i.indexrelid) AS indexdef, t.relnatts AS indnkeys, i.indkey, i.indisclustered, i.indisreplident, t.relpages, c.contype, c.conname, c.condeferrable, c.condeferred, c.tableoid AS contableoid, c.oid AS conoid, pg_catalog.pg_get_constraintdef(c.oid, false) AS condef, (SELECT spcname FROM pg_catalog.pg_tablespace s WHERE s.oid = t.reltablespace) AS tablespace, t.reloptions AS indreloptions FROM pg_catalog.pg_index i JOIN pg_catalog.pg_class t ON (t.oid = i.indexrelid) LEFT JOIN pg_catalog.pg_constraint c ON (i.indrelid = c.conrelid AND i.indexrelid = c.conindid AND c.contype IN ('p','u','x')) WHERE i.indrelid = '16599'::pg_catalog.oid AND i.indisvalid AND i.indisready ORDER BY indexname

Process returned exit code 1.

  • 2
    Sounds like your catalog is corrupted. Perhaps you should restore your database from an earlier base backup (which you certainly have, right?)
    – mustaccio
    Commented Jul 4 at 21:28
  • Not actually. I have a backup too old Commented Jul 6 at 17:14


Browse other questions tagged or ask your own question.