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
aklaver@comcast.net