HI,
I am using PostgreSQL 8.4 in windows XP. Also using Slony-I for implementing master/slave support. I have a data base with some tables and a table space with some other tables in another location. My issue is that after a 30 days continuous run, some of the files in the PostgreSQL table space get deleted. The modification that I had made recently is that, I have created indexes on some of the tables in the table space. But the indexes are actually created on the default table space, not in the table space where the tables resides. Is any problem in it? Note that there is antivirus or clan up applications running on the system. The only thing that we have done is that , the machine has restarted 5 – 6 times without stopping the PostgreSQL server. (The PostgreSQL server running on 5432 post is a custom database server created and not the default PostgreSQL server coming when PostgreSQL is installed.) Is there any chances for failing the crash recovery? Is there any chance for deleting the table space files, if the crash recovery is failed ? How can we avoid this ?
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.