Re: Tablespace files deleted automatically.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux