"Vishnu S." <vishn...@nestgroup.net> wrote: > 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.? If you have any anti-virus software installed, that would be my first suspicion, even if that software is "disabled". You normally need to uninstall AV software to prevent it from causing problems with a database. The second thing I would check is whether your storage system is reliable. What file system are you using against what sort of hardware? Improperly configured media or flaky drivers could be the cause. Other hardware could be at fault -- I've seen disks malfunction due to a faulty UPS sending power spikes into the system. Bad RAM can cause all sorts of weird problems, including lost files. It's not impossible that this is a PostgreSQL bug, but it seems far less likely to me than the above, and you haven't provided nearly enough detail to allow anyone to find such a bug if it does exist. http://wiki.postgresql.org/wiki/Guide_to_reporting_problems > How can we recover from this? If you're talking about recovering data from the deleted files, your best bet would be to go to your backup. This is where Point In Time Recovery (PITR) backups can be very useful. If you don't have the data on a backup, you could try to salvage the files with an OS utility of some sort. If you're talking about not having a recurrence of the problem, that's pretty hard to say without identifying the problem. > 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? Using what techniques? DELETE FROM <tablename>? TRUNCATE TABLE <tablename>? DROP TABLE on partitions? Something else? -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
