Re: Tablespace files deleted during continuous run

On Thu, Oct 13, 2011 at 6:55 AM, Vishnu S. <vishnu(dot)s(at)nestgroup(dot)net> wrote:
>
>
> HI,
>
> 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?

You're gonna have to tell us more about your setup, how you created
the tablespace etc. You're not giving anyone enough information to
help you just yet.