Re: pgsql.broken.csc - Mailing list pgsql-general

From M Rather
Subject Re: pgsql.broken.csc
Date
Msg-id 4727635B.6010101@definedlogic.com
Whole thread Raw
In response to Re: pgsql.broken.csc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote: <blockquote cite="mid:24470.1193762916@sss.pgh.pa.us" type="cite"><pre wrap="">M Rather <a
class="moz-txt-link-rfc2396E"href="mailto:mrather@definedlogic.com"><mrather@definedlogic.com></a> writes:
</pre><blockquotetype="cite"><pre wrap="">one of our clients is using pgsql 8.1, and recently the site crashed due 
 
to lack of hard disk space. Upon inspection a file was found :   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">pgsql.broken.csc  (size: > 51 GB)   </pre></blockquote><pre wrap=""> </pre><blockquote
type="cite"><prewrap="">I cannot find any reference to this file on pgsql site or on google.   </pre></blockquote><pre
wrap=""></pre><blockquote type="cite"><pre wrap="">What is this file? Is it related to PGSQL? What caused it to grow to

this size?   </pre></blockquote><pre wrap="">
PG would never make a file named that.

Did you try looking into the file to see what it contains?
        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
 </pre></blockquote> I should have mentioned this in my original email.<br /> Unfortunately the file was deleted by the
hostingservice (our client had OK'd it) to bring the site backup immediately.<br /><br /> I may have to see if some
otherprocess (valid or malicious) may have created the file. <br /><br /> Thanks and Regards<br /> -MRather<br /> 

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pgsql.broken.csc
Next
From: Howard Cole
Date:
Subject: Table has type character varying, but query expects character varying