Tablespace issue

Hi,

I have a PostgreSQL 8.4 database running on local machine IP and port
5432 ( The default PostgreSQL server is stopped manually). I have also
created a tablespace in another drive and some tables in it.

The tablespace is created using CREATE TABLESPACE query. Some of the
tables contain bytea field. The table updating in every second. About 2
MB data is inserted into the tables every second.

Issue is that after a 20 - 30 days continuous run, it is observed that
the tables created on the tablespace are not accessible via pgAdmin.
This was because some files are missing from the tablespace directory.
When ever we looked into the tablespace folder, the PG_VERSION file was
not present there. Also some of the files are missing from the \16384
folder of the tablespace.

How this is happened. No antivirus software is installed in the system.
No hardware failure.

I have an application that inserts bulk data into the tables in the
tablespace usually in 1 hour interval. Is there any issue if a
transaction is failed. In such a case is there any possibility to delete
the tablespace?

The same application also deletes the contents of the tables in the
tablspace after 10 days. The deletion is done using DELETE FROM query.
Is there any possibility that the tablespace get deleted?

The connection to the database tables that are created in the default
tablespace are working fine. How this is happened. Can anyone tell me
how the tablespace files are deleted? What is the reason for it? How
can I recover my files back? How will we ensure no data loss using
PostgreSQL tablespace?

Thanks & Regards,

Vishnu S

***** Confidentiality Statement/Disclaimer *****

This message and any attachments is intended for the sole use of the intended recipient. It may contain confidential information. Any unauthorized use, dissemination or modification is strictly prohibited. If you are not the intended recipient, please notify the sender immediately then delete it from all your systems, and do not copy, use or print. Internet communications are not secure and it is the responsibility of the recipient to make sure that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.