| From: | Sergei Kornilov <sk(at)zsrv(dot)org> |
|---|---|
| To: | "murthy(dot)mvvs(at)gmail(dot)com" <murthy(dot)mvvs(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #15110: Unable to backup database |
| Date: | 2018-03-14 11:46:16 |
| Message-ID: | 1937951521027976@web56o.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello
This error message say your underlying filesystem returned less bytes than it should be. Usually this means storage was corrupted and 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 (better having another copy PGDATA).
regards, Sergei
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Devrim Gündüz | 2018-03-14 15:59:03 | Re: BUG #15108: Initialization problem postgresql-10-setup initdb |
| Previous Message | PG Bug reporting form | 2018-03-14 10:42:31 | BUG #15110: Unable to backup database |