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.gif@01C92A25.A541A8B0 cid:image002.gif@01C92A25.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.valsa...@sphere.ae> preethi.valsa...@sphere.ae <http://www.sphere.ae> www.sphere.ae
<<image002.gif>>
<<image003.gif>>
<<image001.jpg>>
