|
HI, I am using PostgreSQL 8.4 in windows. I have created
a database and some tables on it. Also created a table space and some tables in
it. My application inserts data into these tables in every
second. The application is a continuous running application. My issue is that after a 20-30 days continuous run ( Machine
logged off 2 times), some of the files in the \16384 folder of
newly created table space are dropped automatically. Can you tell me the reason for this.? How can we
recover from this? I have a task that delete the data(only data stored in table)
from the tables in the tablespace in certain interval. Is there any
problem related to this? Can you tell me the reason for this? Thanks & Regards, Vishnu S 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. |
