RE: Loosing files after backend crash

Mikheev, Vadim <vmikheev@sectorbase.com>

From: "Mikheev, Vadim" <vmikheev@SECTORBASE.COM>
To: "'ks@tcnet.ru'" <ks@tcnet.ru>, "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>
Date: 2001-04-02T22:14:13Z
Lists: 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