Tablespace files deleted in continuous run - Mailing list pgsql-bugs

From Vishnu S.
Subject Tablespace files deleted in continuous run
Date
Msg-id D0124DE0373A744CA8192AFA82C8311707BE684E@mail-4.tvm.nestgroup.net
Whole thread Raw
Responses Re: Tablespace files deleted in continuous run  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Tablespace files deleted in continuous run  ("Nathan M. Davalos" <n.davalos@sharedmarketing.com>)
List pgsql-bugs
=20

=20

HI,

=20

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?

=20

=20

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?

=20

=20

Thanks & Regards,

Vishnu S

=20

=20

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

This message and any attachments is intended for the sole use of the intend=
ed 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 fro=
m 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 t=
hat it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations o=
r modifications made to the contents. If you require any form of confirmati=
on of the contents, please contact the company/sender. The company/sender i=
s not liable for any errors or omissions in the content of this message.

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'
Next
From: "Kevin Grittner"
Date:
Subject: Re: Tablespace files deleted in continuous run