|
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 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. |
