Re: Postgres log file - Mailing list pgsql-admin

On Linux at least - not sure about Windows - deleting a file does not remove it from the file system until there are
nomore processes holding the file open.<br /> So while postgres holds the file open, it can keep writing to it
happily.<br/> You won't be able to see the file in the directory, and the space won't be freed. You can find such
thingswith the "find"command by looking for files with a link count of zero.<br /><br /><br /> On 10/15/2010 11:03 AM,
JessicaRichard wrote: <blockquote cite="mid:165713.55278.qm@web111313.mail.gq1.yahoo.com" type="cite"><style
type="text/css"><!--DIV {margin:0px;} --></style><div style="font-family: times new roman,new york,times,serif;
font-size:12pt;">I am curious about this scenario:<br /><br /> What is going to happen when a server is running and the
Postgreslog file is accidentally deleted or renamed?  The server will have no place to write its log entries
obviously..what else?.<br /><br /> Is there any way to check within Postgres what the current log name (with a
particulartime stamp when rotated last time) is so that a file with a correct  matching name can be manually
created?<br/><br /> For this situation, what is the proper way to get the server to write to a new log file without
havingto bounce the Postgres server itself?<br /><br /> Thanks!<br /><br /><br /></div><br /></blockquote><br /><br
/><divclass="moz-signature">-- <br /><style type="text/css">.sig, .sig a, .sig td { font: 12px Arial; color: DarkBlue;
white-space:nowrap; vertical-align: top; text-align: left; }.sig img { border: 0pt none; }.sig a { font: 11px Arial;
}.sig.back { color: rgb(255, 255, 255); background-color: DarkBlue; text-decoration: none; }.sig .right { text-align:
right;}.sig .border { border: 1px solid DarkBlue; margin: 5px; border-collapse: collapse; }.sig .bottom {
vertical-align:bottom; }.sig p { clear: both; margin: 2px; }</style><div class="sig"><table
class="border"><tbody><tr><tdclass="back"> <b>Steve Francis</b></td><td class="back" style="width: 30px;"><br
/></td><tdclass="back" style="text-align: right;"><b>LogicMonitor LLC</b></td></tr><tr><td><br /></td><td><br
/></td><tdclass="right"><br /></td></tr><tr><td class="bottom"><a class="moz-txt-link-abbreviated"
href="mailto:sfrancis@logicmonitor.com">sfrancis@logicmonitor.com</a><br/> Monitoring Made Easy<br /><a
href="http://www.logicmonitor.com"target="_blank">www.logicmonitor.com</a></td><td><br /></td><td class="bottom"
style="text-align:right;"> Ph: 1 888 41 LOGIC x500<br /> Ph: 1 805 698 0770</td></tr></tbody></table><p>  <br
/></div></div>