On Sunday 01 February 2009 12:38:21 am Preethi Valsalan wrote: > 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. >
You will need to supply more information to start the troubleshooting process: Postgres version OS type and version What is your application doing? Are there other application running that touch the db or its data directory? >From this particular post what does "on runtime Postgres stopped running" mean? Thanks, -- Adrian Klaver akla...@comcast.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
