RE: Loosing files after backend crash - Mailing list pgsql-bugs

From Mikheev, Vadim
Subject RE: Loosing files after backend crash
Date
Msg-id 8F4C99C66D04D4118F580090272A7A234D3367@sectorbase1.sectorbase.com
Whole thread Raw
In response to Loosing files after backend crash  (pgsql-bugs@postgresql.org)
List 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 by date:

Previous
From: "Darren King"
Date:
Subject: RE: compilation error
Next
From: "Miguel A. Juan"
Date:
Subject: Unexpected query results