From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | ray <Ray(dot)Joseph(at)CDICorp(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to initiate a new log file? |
Date: | 2009-05-27 00:38:06 |
Message-ID: | 4A1C8B6E.1070708@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
ray wrote:
> While debugging applications interacting with pg, the log file (under
> pg_log) gets quite long. The log file typically has a name such as
> postgresql-2009-05-26_000000.log; sometimes an new file will be
> generated on the same day and the portion of the name that is all
> zeroes will change to a larger number for each change during that day.
>
> I would like to know what triggers the name change and how can I force
> a change.
>
by default, a new log is created at midnight (hence the _000000) and
when the server is restarted (which would have a timestamp related to
when it was restarted)
you can force a new logfile with...
SELECT |pg_rotate_logfile|();
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2009-05-27 01:04:50 | Re: How to speed up the first-time-searching in pgsql? |
Previous Message | John R Pierce | 2009-05-27 00:20:13 | Re: How to speed up the first-time-searching in pgsql? |