| From: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM> |
|---|---|
| To: | "'ks(at)tcnet(dot)ru'" <ks(at)tcnet(dot)ru>, "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | RE: Loosing files after backend crash |
| Date: | 2001-04-02 22:14:13 |
| Message-ID: | 8F4C99C66D04D4118F580090272A7A234D3367@sectorbase1.sectorbase.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-04-02 23:34:42 | Re: Loosing files after backend crash |
| Previous Message | pgsql-bugs | 2001-04-02 21:45:28 | Loosing files after backend crash |