urgent request : PSQLException: FATAL: could not open relation XXX: No such file or directory

Hi

I am working on an application where Postgresql is used as the db. I have a
trigger and three functions running on that trigger. The data in db is
updated by a thread each 1 minute continuously.

I kept my application running for 2 days and on runtime Postgres stopped
running. But when I restarted it and restarted my application I got the
error "PSQLException: FATAL: could not open relation XXX: No such file or
directory" . I found that some of the files in the db(data folder) are
lost(just dissappeared). Can u explain me why it happened and how can I fix
this problem, since this is blocking my application.

cid:image001(dot)gif(at)01C92A25(dot)A541A8B0

cid:image002(dot)gif(at)01C92A25(dot)A541A8B0

Warm regards,

Preethi K Valsalan, Team Lead

Sphere Networks FZCo. P.O.Box 341010, Dubai UAE

Tel: (+9714) 501-5863 Fax: (+9714) 501-5872

<mailto:preethi(dot)valsalan(at)sphere(dot)ae> preethi(dot)valsalan(at)sphere(dot)ae

<http://www.sphere.ae> www.sphere.ae