Re: Tablespace files deleted automatically.

Vishnu,

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

PostgreSQL creates and deletes files all the time.  I don't understand
why this is a problem.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com