From: Steve Francis <sfrancis@logicmonitor.com>
To: pgsql-admin@postgresql.org
Subject: Re: Postgres log file
Date: Fri, 15 Oct 2010 11:15:37 -0700
Message-ID: <4CB89A49.80208@logicmonitor.com> (raw)
In-Reply-To: <165713.55278.qm@web111313.mail.gq1.yahoo.com>
References: <1287085384.1684.52.camel@tony1.localdomain>
<F4C27E77F7A33E4CA98C19A9DC6722A2069F3459@EXCHANGE.corp.perceptron.com>
<165713.55278.qm@web111313.mail.gq1.yahoo.com>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
On Linux at least - not sure about Windows - deleting a file does
not remove it from the file system until there are no more 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 things with the "find"command by
looking for files with a link count of zero.<br>
<br>
<br>
On 10/15/2010 11:03 AM, Jessica Richard 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
Postgres log 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 particular time 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 having to bounce the Postgres
server itself?<br>
<br>
Thanks!<br>
<br>
<br>
</div>
<br>
</blockquote>
<br>
<br>
<div class="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>
<td class="back"> <b>Steve Francis</b></td>
<td class="back" style="width: 30px;"><br>
</td>
<td class="back" style="text-align: right;"><b>LogicMonitor
LLC</b></td>
</tr>
<tr>
<td><br>
</td>
<td><br>
</td>
<td class="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 target="_blank" href="http://www.logicmonitor.com">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>
</p>
</div>
</div>
</body>
</html>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrancis@logicmonitor.com, pgsql-admin@postgresql.org
Subject: Re: Postgres log file
In-Reply-To: <4CB89A49.80208@logicmonitor.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox