Re: Backup postgres

Hola Freddy.

Sent with Proton Mail secure email.

On Tuesday, August 20th, 2024 at 12:11, Fredy Hurtado <fhurtado(at)grupoasd(dot)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