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