Re: Tablespace files deleted during continuous run - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Tablespace files deleted during continuous run
Date
Msg-id CAOR=d=00sOZux5qite_BmqADnCNxzkvO9EQzSBjYDzGUBvq3xg@mail.gmail.com
Whole thread Raw
In response to Tablespace files deleted during continuous run  ("Vishnu S." <vishnu.s@nestgroup.net>)
List pgsql-general
On Thu, Oct 13, 2011 at 6:55 AM, Vishnu S. <vishnu.s@nestgroup.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.

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: could not reattach to shared memory
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] Trying to use binary replication - from tutorial