Re: BUG #15110: Unable to backup database

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: BUG #15110: Unable to backup database
Дата
Msg-id 1937951521027976@web56o.yandex.ru
обсуждение исходный текст
Ответ на BUG #15110: Unable to backup database  (PG Bug reporting form <noreply@postgresql.org>)
Список 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 по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15110: Unable to backup database
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: BUG #15108: Initialization problem postgresql-10-setup initdb