Re: BUG #15110: Unable to backup database - Mailing list pgsql-bugs

From Sergei Kornilov
Subject Re: BUG #15110: Unable to backup database
Date
Msg-id 1937951521027976@web56o.yandex.ru
Whole thread Raw
In response to BUG #15110: Unable to backup database  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Hello
This error message say your underlying filesystem returned less bytes than it should be. Usually this means storage was
corruptedand should be checked by sysadmins.
 
https://github.com/postgres/postgres/blob/REL_10_STABLE/src/backend/storage/smgr/md.c#L776

So i suggest shutdown database, then copy full PGDATA directory, check disks and filesystem and recover database from
backup.Or you may try enable zero_damaged_pages (this removes your data in such pages!) and copy the surviving data
(betterhaving another copy PGDATA).
 

regards, Sergei


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15110: Unable to backup database
Next
From: Devrim Gündüz
Date:
Subject: Re: BUG #15108: Initialization problem postgresql-10-setup initdb