From: Jessica Richard <rjessil@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Postgres log file
Date: Fri, 15 Oct 2010 11:03:12 -0700 (PDT)
Message-ID: <165713.55278.qm@web111313.mail.gq1.yahoo.com> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A2069F3459@EXCHANGE.corp.perceptron.com>
References: <1287085384.1684.52.camel@tony1.localdomain>
<F4C27E77F7A33E4CA98C19A9DC6722A2069F3459@EXCHANGE.corp.perceptron.com>
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!
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: rjessil@yahoo.com, pgsql-admin@postgresql.org
Subject: Re: Postgres log file
In-Reply-To: <165713.55278.qm@web111313.mail.gq1.yahoo.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