[BUGS] strange disappearence of postgres file

[Harald Armin Massa]

I ran into a very strange disappearance of a postgresql data file.

The environment:

Windows XP professional

select version();
 PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)

All datafiles are within c:\ghum\data

that part of the harddrive is only accessable to user account postgres (= the one running the service) and Administrator.

the logentries:

postgresql-2005-11-21_080758.log
2005-11-21 08:08:05 LOG:  startup process (PID 1220) exited with unexpected status 128
2005-11-21 08:08:05 LOG:  aborting startup due to startup process failure
2005-11-21 08:08:06 LOG:  logger shutting down

postgresql-2005-11-21_084022.log
2005-11-21 08:40:24 LOG:  database system was shut down at 2005-11-20 16:46:29 Westeuropäische Normalzeit
2005-11-21 08:40:24 LOG:  checkpoint record is at 4/2C880BC0
2005-11-21 08:40:24 LOG:  redo record is at 4/2C880BC0; undo record is at 0/0; shutdown TRUE
2005-11-21 08:40:24 LOG:  next transaction ID: 421189; next OID: 381050
2005-11-21 08:40:24 LOG:  database system is ready
2005-11-21 09:45:50 ERROR:  could not open relation 1663/17253/43471: No such file or directory
2005-11-21 09:45:52 ERROR:  could not open relation 1663/17253/43471: No such file or directory
2005-11-21 09:45:59 ERROR:  could not open relation 1663/17253/43471: No such file or directory
2005-11-21 09:46:09 ERROR:  could not open relation 1663/17253/43471: No such file or directory
2005-11-21 09:46:30 ERROR:  could not open relation 1663/17253/43471: No such file or directory

... and on and on and on...

My checking showed that... within directory data/base/17253 there is indeed no file named 43471; but ones named 43470,43472,43473 .....

Additional Information: that is a laptop-computer, and it is quite possible that it was restarted between 8:08 and 8:40 this morning.

But ... I see no line mentioning a "killing of a file". Can I do something more to find out WHY this file disappeared?  (and esp. make sure that no more files disappear :( )

Harald


--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607