it looks like my DB got corrupted.
🗄️Server❓Question
i got this error:
Job Failed
Job DatabaseBackup failed with error:
/usr/lib/postgresql/14/bin/pg_dump
non-zero exit code (1)
pg_dump: error: Dumping the contents of table "memory_audit" failed:
PQgetResult() failed.
pg_dump: error: Error message from server:
ERROR: invalid page in block 5 of relation base/16384/567612
pg_dump: error: The command was:
COPY public.memory_audit
(id, "memoryId", "userId", "deletedAt")
TO stdout;
when triying to make a database backup.
so i asked chatgpt to transcribe the screenshot from the error notification and to help me, it told me to backup manually the DB without including public.memory_audit.
can i safely drop public.memory_audit?
Job Failed
Job DatabaseBackup failed with error:
/usr/lib/postgresql/14/bin/pg_dump
non-zero exit code (1)
pg_dump: error: Dumping the contents of table "memory_audit" failed:
PQgetResult() failed.
pg_dump: error: Error message from server:
ERROR: invalid page in block 5 of relation base/16384/567612
pg_dump: error: The command was:
COPY public.memory_audit
(id, "memoryId", "userId", "deletedAt")
TO stdout;
when triying to make a database backup.
so i asked chatgpt to transcribe the screenshot from the error notification and to help me, it told me to backup manually the DB without including public.memory_audit.
can i safely drop public.memory_audit?
