Backup postgres

From: Fredy Hurtado <fhurtado(at)grupoasd(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Backup postgres
Date: 2024-08-20 18:11:38
Message-ID: c6bd32cd-7558-4de7-8c87-2ecaef9c0be7@grupoasd.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buenas tardes,

Estoy generando un backup en Postgres 15.7 sobre Debian 12 y al momento
de lanzarlo, me aparece este error:

pg_dump: error: la consulta falló: ERROR:  no se pudo leer el bloque 0
del archivo «base/36094/3119»: Error de entrada/salida
pg_dump: detalle: La consulta era: SELECT c.tableoid, c.oid, c.relname,
c.relnamespace, c.relkind, c.reltype, c.relowner, c.relchecks,
c.relhasindex, c.relhasrules, c.relpages, c.relhastriggers,
c.relpersistence, c.reloftype, c.relacl, acldefault(CASE WHEN c.relkind
= 'S' THEN 's'::"char" ELSE 'r'::"char" END, c.relowner) AS acldefault,
CASE WHEN c.relkind = 'f' THEN (SELECT ftserver FROM
pg_catalog.pg_foreign_table WHERE ftrelid = c.oid) ELSE 0 END AS
foreignserver, c.relfrozenxid, tc.relfrozenxid AS tfrozenxid, tc.oid AS
toid, tc.relpages AS toastpages, tc.reloptions AS toast_reloptions,
d.refobjid AS owning_tab, d.refobjsubid AS owning_col, tsp.spcname AS
reltablespace, false AS relhasoids, c.relispopulated, c.relreplident,
c.relrowsecurity, c.relforcerowsecurity, c.relminmxid, tc.relminmxid AS
tminmxid,
array_remove(array_remove(c.reloptions,'check_option=local'),'check_option=cascaded')
AS reloptions, CASE WHEN 'check_option=local' = ANY (c.reloptions) THEN
'LOCAL'::text WHEN 'check_option=cascaded' = ANY (c.reloptions) THEN
'CASCADED'::text ELSE NULL END AS checkoption, am.amname, (d.deptype =
'i') IS TRUE AS is_identity_sequence, c.relispartition AS ispartition
FROM pg_class c
LEFT JOIN pg_depend d ON (c.relkind = 'S' AND d.classid =
'pg_class'::regclass AND d.objid = c.oid AND d.objsubid = 0 AND
d.refclassid = 'pg_class'::regclass AND d.deptype IN ('a', 'i'))
LEFT JOIN pg_tablespace tsp ON (tsp.oid = c.reltablespace)
LEFT JOIN pg_am am ON (c.relam = am.oid)
LEFT JOIN pg_class tc ON (c.reltoastrelid = tc.oid AND tc.relkind = 't'
AND c.relkind <> 'p')
WHERE c.relkind IN ('r', 'S', 'v', 'c', 'm', 'f', 'p')
ORDER BY c.oid

Alguien me podría indicar por qué sucede eso

Cordialmente,

--

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martin H. Rmz 2024-08-20 18:48:25 Re: Backup postgres
Previous Message Alvaro Herrera 2024-08-16 00:16:13 Re: Creación de una replica adicional