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: | Raw Message | Whole Thread | 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 |