Hola Freddy.
Sent with Proton Mail secure email.
On Tuesday, August 20th, 2024 at 12:11, Fredy Hurtado <fhurt...@grupoasd.com>
wrote:
> 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,
>
> --
El error me suena a :
=> Corrupción [1]
=> Permisos sobre los archivos de PostgreSQL (base/36094/3119)
Revisa este Post [2].
Me paso una vez y tuve suerte recuperando el archivo haciendo esto :
=> Copiar el archivo dañado en la misma ubicación y renombrarlo.
[1] - https://wiki.postgresql.org/wiki/Corruption
[2] -
https://www.postgresql.org/message-id/CAM%2B6J96mtU%2BZmD%3Dz9kfHzhj%3DK_dTJoZJ3iBDADxpbTcNYTjaQA%40mail.gmail.com
