Tablespace files dropped automatically.

From: "Vishnu S(dot)" <vishnu(dot)s(at)nestgroup(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Tablespace files dropped automatically.
Date: 2011-10-07 06:06:04
Message-ID: D0124DE0373A744CA8192AFA82C831170799F65C@mail-4.tvm.nestgroup.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am Using PostgreSQL 8.4 along with Slony-I replication in windows XP.
A client application continuously updating data to the database.

In my database some tables are in default database and some tables are
in another tables. My issue is that after a moth's running, some of the
files in the 16384 folder of the external table space get deleted
automatically. Now an error message is showing in pgAdmin saying that
"could not open relation pg_tblspc/16385/16384/16783: No such file or
directory."

What is the reason for this?

Is the tablespace files are dropped automatically?

In which condition, the table space files get deleted? What is the
reason ? and What is the Possible solution.

Thanks & Regards,

Vishnu S

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

This message and any attachments is intended for the sole use of the intended 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 from 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 that it is virus/malicious code exempt.
The company/sender cannot be responsible for any unauthorized alterations or modifications made to the contents. If you require any form of confirmation of the contents, please contact the company/sender. The company/sender is not liable for any errors or omissions in the content of this message.

Browse pgsql-admin by date

  From Date Subject
Next Message Karuna Karpe 2011-10-07 06:12:20 Some Postgresql Concepts
Previous Message Joshua D. Drake 2011-10-05 23:53:27 Re: pg9 replication over WAN ?