On Thu, Oct 13, 2011 at 10:12 PM, Vishnu S. <vishnu.s@xxxxxxxxxxxxx> wrote: > Hi, > > > The tablespace is created using CREATE TABLESPACE query. Is it a local drive? USB or eSATA maybe? > Also Slony-I replication is working on the tablespace for Master - slave implementation. should work. I've done it before with no problems. > The machine has logged off 5-6 times without stopping the server. Do you mean that it's logged off the local user who was logged in? > Is there any problem on it. If yes why this is happening? > > I have an application that deletes data from the tables that are in the tablespace. > The Query used for deletion is DELETE FROM <table> WHERE <condition>. > > > Also the tablespace contains about 7-8 GB data. Is there any problem in it. > Is there any size limit for tablespace in PostgreSQL.(Documentation says no). 7 to 8 gig is small by pg standards. > The problem was occurred twice. In first situation all the files in the tablespace are get deleted. > In second condition some folders in \16384 was present. But the files including the PG_VERSION are get deleted. Well something is deleting the files, and it's not likely postgres. > No anti virus application is installed on the system.(Both in master and slave) > Is there any possibility that Slony-I will delete the tablespace files? Nope. Any odd power outages or disconnected drives? chkdsk finding problems on bootup etc? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
