pg.ddx.io pgsql-es-ayuda@postgresql.org mailing list archive
help / color / mirror / Atom feedBackup postgres
3+ messages / 3 participants
[nested] [flat]
* Backup postgres
@ 2024-08-20 18:11 Fredy Hurtado <fhurtado@grupoasd.com>
2024-08-20 18:48 ` Re: Backup postgres Martin H. Rmz <Martin.H.Rmz@protonmail.ch>
2024-08-20 22:01 ` Re: Backup postgres Alvaro Herrera <alvherre@alvh.no-ip.org>
0 siblings, 2 replies; 3+ messages in thread
From: Fredy Hurtado @ 2024-08-20 18:11 UTC (permalink / raw)
To: 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,
--
Attachments:
[image/png] Fredy-Guillermo-Hurtado-Jimenez-.png (62.1K, ../../c6bd32cd-7558-4de7-8c87-2ecaef9c0be7@grupoasd.com/3-Fredy-Guillermo-Hurtado-Jimenez-.png)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup postgres
2024-08-20 18:11 Backup postgres Fredy Hurtado <fhurtado@grupoasd.com>
@ 2024-08-20 18:48 ` Martin H. Rmz <Martin.H.Rmz@protonmail.ch>
1 sibling, 0 replies; 3+ messages in thread
From: Martin H. Rmz @ 2024-08-20 18:48 UTC (permalink / raw)
To: Fredy Hurtado <fhurtado@grupoasd.com>; +Cc: pgsql-es-ayuda
Hola Freddy.
Sent with Proton Mail secure email.
On Tuesday, August 20th, 2024 at 12:11, Fredy Hurtado <fhurtado@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%40...
Attachments:
[image/png] Fredy-Guillermo-Hurtado-Jimenez-.png (62.1K, ../../dP9DAUCvhww33k-fbSBdurGdorfi9lCRkoDTJGh2IfmPQ6fOnO83vWvI5l3oAoXw__4x3sdBjlYFNrlPinqUj4Rv-BJonN6ZBSEaj2kKRdc=@protonmail.ch/2-Fredy-Guillermo-Hurtado-Jimenez-.png)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Backup postgres
2024-08-20 18:11 Backup postgres Fredy Hurtado <fhurtado@grupoasd.com>
@ 2024-08-20 22:01 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
1 sibling, 0 replies; 3+ messages in thread
From: Alvaro Herrera @ 2024-08-20 22:01 UTC (permalink / raw)
To: Fredy Hurtado <fhurtado@grupoasd.com>; +Cc: pgsql-es-ayuda
Fredy Hurtado escribió:
> 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
Ese error viene del sistema operativo, y muy probablemente indica que
uno de tus discos está muriendo.
3119 es un índice en el catálogo de sistema pg_foreign_table. Quizás
puedas recuperar esto haciendo REINDEX TABLE pg_foreign_table en la base
de datos afectada, aunque nunca se puede saber si no tienes corrupción
en alguna otra parte, especialmente en archivos con datos de tabla.
Recomendaría que saques tus datos de esa máquina, o de ese disco, para
restaurarlos en una máquina confiable, antes de seguir operando.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"La vida es para el que se aventura"
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-20 22:01 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-20 18:11 Backup postgres Fredy Hurtado <fhurtado@grupoasd.com>
2024-08-20 18:48 ` Martin H. Rmz <Martin.H.Rmz@protonmail.ch>
2024-08-20 22:01 ` Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox