RE: Loosing files after backend crash

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Loosing files after backend crash
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D3367@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на Loosing files after backend crash  (pgsql-bugs@postgresql.org)
Список pgsql-bugs
> The "relfilenode" attribute of the tuple contained the value
> "326210". I tried to find the file with that name in the
> database directory - it really was not there.

Did you look in lost+found?

> Thus, the backend crash has led not only to impossibility to
> complete my task, but also to loosing some data. The sequence
> was actually created in an already committed transaction, not
> in the one, that crashed.

How much time passed after sequence creation till crash?
Did you use -F (fsync = NO)?

Vadim

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Darren King"
Дата:
Сообщение: RE: compilation error
Следующее
От: "Miguel A. Juan"
Дата:
Сообщение: Unexpected query results