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 />