How to initiate a new log file?

Started by rayalmost 17 years ago2 messagesgeneral
Jump to latest
#1ray
Ray.Joseph@CDICorp.com

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.

Thanks,
Ray

#2John R Pierce
pierce@hogranch.com
In reply to: ray (#1)
Re: How to initiate a new log file?

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|();