pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres log file
2+ messages / 2 participants
[nested] [flat]
* Postgres log file
@ 2010-10-15 18:03 Jessica Richard <rjessil@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jessica Richard @ 2010-10-15 18:03 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
I am curious about this scenario:
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?.
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?
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?
Thanks!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Postgres log file
@ 2010-10-15 18:15 Steve Francis <sfrancis@logicmonitor.com>
parent: Jessica Richard <rjessil@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Steve Francis @ 2010-10-15 18:15 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
<!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>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-10-15 18:15 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-10-15 18:03 Postgres log file Jessica Richard <rjessil@yahoo.com>
2010-10-15 18:15 ` Steve Francis <sfrancis@logicmonitor.com>
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